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.

Vinay Singh · Answer

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

Vishal Jadav · Answer

Hi Its just the idea try to use the import functionality of SQL server. Hope it helps. Thanks.