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 |
|
bvanyangu
Starting Member
20 Posts |
 Posted - 2014-03-24 : 08:48:30
|
| Can anyone help me out how to extract data from 3 excel sheets (same excel doc having multiple sheets with different # of columns & rows) using SSIS 2008.The end result will be 6 tables loaded in the database. I am not so familiar yet with SQL Task or Stored Procedure.Thanks in Advance |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2014-03-24 : 10:33:17
|
| In SSMS right click the DB you want to import the sheets to, select Tasks - Import Data...select Excel as the source and select DB destination...select sheet from list, this will create a new table for the selected sheet(s) on the DB.If you will it you can achieve it!! |
 |
|
|
|
|
|
Excel File