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 |
|
rocepp
Starting Member
1 Post |
 Posted - 2006-04-19 : 11:02:32
|
| I have about 6 excel files with multiple worksheets in each, they all have the same field layout. I'd like to import each worksheet into a one table of my sql database, i'd also like to be able to seed a field on that table that will take the worksheet name so that i can run queries on the table at a later date. Is there a way to accomplish this? |
|
|
Krankensteins
Starting Member
24 Posts |
Posted - 2006-04-20 : 01:01:08
|
| Excel docs and worksheets names are constants? Then that is posible. If You want in single DTS script then manualy need create them. If sepratly then on each Excel one DTS by Import&Export wizard just check im to save DTS for leter use. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
batch import