How to import Excel sheet data into a SQL Server Table.

[Weese]

Hi Friends,
I am having one excel file which needs to be converted into a SQL Table. I need to use asp.net. Please let me know if there is any way to do it. Pointers to the sample program would be very useful. Thanks a lot in advance.

 

[DotNetGnat]

This is ASP forum. You may want to post this in ASP.NET forum forum855

-DNG

 

[Sheco]

The easiest way to do it might be to use MSAccess to connect to your database, import the Excel file into Access, and upload it that way.

Or do you want to parse uploaded files and use the results to build a CREATE TABLE command in SQL... run the command... and then flip through the rows of the spreadsheet while doing SQL INSERTs?

Or, even better if you are doing multiples would be to use DTS inside of SQL Server. You can script DTS packages using VBScript so that should be familiar enough to use.