SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 
        
Home       Members    Calendar    Who's On



DTS: How to Import Excel to SQL Server Expand / Collapse
Author
Message
Posted Thursday, August 07, 2008 7:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 06, 2009 7:35 PM
Points: 10, Visits: 51
Can anyone help me with this, I want to Import an Excel file to my SQL server DB, I have several excel file that is located on a specific table, the worksheet firmat are all the same but the worksheetname for each excel file seems to have different name. I have about 2000 excel file and I want them to be loaded in my SQL server DB.



Thanks to your Response! :)
Post #548797
« Prev Topic | Next Topic »


Permissions Expand / Collapse