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 |
|
xhostx
Constraint Violating Yak Guru
277 Posts |
 Posted - 2012-08-02 : 09:07:14
|
| Hi,I have about 100 .xls files which I need to dump into a one Table SQL server 2008. They all have the same structure.I know this is can be done using the BID, however, I would like some directions or a process of how to do it.Steps of the process would be very appreciated.Thanks,--------------------------Get rich or die trying-------------------------- |
|
|
shan
Yak Posting Veteran
84 Posts |
Posted - 2012-08-02 : 16:14:31
|
| You may use For each loop container and Select ForEach File Enumerator to loop trough each file and load it to table.-Shan |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-08-03 : 01:55:09
|
| Either create a SSIS package implementing ideas suggested above , or you can script through Powershell - which can easily read all the files (loop through) and import to tableJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-03 : 09:57:35
|
quote:
Originally posted by xhostx
Hi,I have about 100 .xls files which I need to dump into a one Table SQL server 2008. They all have the same structure.I know this is can be done using the BID, however, I would like some directions or a process of how to do it.Steps of the process would be very appreciated.Thanks,--------------------------Get rich or die trying--------------------------
seehttp://visakhm.blogspot.com/2012/05/package-to-implement-daily-processing.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Import Multiple Excel Files