Bulk copy data from excel sheet to sql table
How to process bulk copy data from excel sheet to sql table. Here is code to copy data from excel to sql. C# Code: string excelFile = @”C:Book1.xls”; string ssqlTable = “[MyTableName]”; string exceldataQuery = “select [id],[email],[status] from [Sheet1$]”; try … Read more