Inserting Excel File Records Into SQL Server Database Using

Question

I Can Append the Records but Not able to Create the new Table from the Coding.

Answer 1

Hi check the link

http://www.aspsnippets.com/Articles/Create-and-Drop-SQL-Server-Table-programmatically-using-ADONet-C-and-VBNet.aspx

For insert record in table

http://www.aspsnippets.com/Articles/Using-SqlBulkCopy-to-import-Excel-SpreadSheet-data-into-SQL-Server-in-ASPNet-using-C-and-VBNet.aspx

Answer 2

Hi,

Its just the idea, try to use the import functionality of SQL server.

Hope it helps.

Thanks.