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 --------------------------
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 table
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 --------------------------
Import Multiple Excel Files
Posted - 08/02/2012 : 09:07:14
