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 |
|
prodigy2006
Yak Posting Veteran
66 Posts |
 Posted - 2009-11-14 : 07:35:02
|
| I've close to 1000 excel sheets and i'd like to create a single package which pulls the data out of 1000 excel sheets and inserts it into a table. Could you guys please explain to me in detail? |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-11-20 : 11:42:03
|
| Create a for Loop container and Loop through all the Excel files..Make sure the sheet names or the ranges and columns are the same for all the excel files.Inside the For loop create a Data Flow task that inserts the records into a table.http://www.sqlserver007.com |
 |
|
|
|
|
|
Excel to a table