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 |
|
aksana
Starting Member
13 Posts |
 Posted - 2008-08-11 : 23:36:07
|
| hi, everyone.I have another qestion about inserting Excel data into DB.is it possible to insert Excel every Sheet's name into DB??My excel file's Each format are the same but sheet name.thank you.aksana |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-12 : 00:28:26
|
| Yup you can. First transfer data from each sheet onto styaging tables. then use SQL command task to put data from all the staging tables onto your destination. |
 |
|
|
|
|
|
Sheet name to DB