Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Unikhath
Starting Member
12 Posts |
 Posted - 2009-05-05 : 19:29:43
|
| Hi,I have to import the excel sheet data into multiple tables in the database using SSIS. For example the column name Region in the Excel sheet goes in the Region table and the Region Id for that entry goes in the main table. I have to check each and every excel cell value to make sure the value does not exist in the region table, If the region value already exists in the Region table then I have to look for Region ID. And also In excel sheet, there are multiple values in 1 single cell like 3 values in 1 cell and I have to create 3 rows in the main table for each corresponding value. For example the Operating system column have 3-4 values in 1 cell, "Windows Vista Business - 32 bitWindows Vista Ultimate - 32 bitWindows Vista Business - 64 bitWindows Vista Ultimate - 64 bit"i have to create 4 rows in the database for each valueThanks |
|
|
|
|
|
Import Excel sheet to multiple tables in Sql 05