How to create SQL Server Table from ExcelSheet in asp c# .net

0
votes

I have used below procedure code but its throwing an error:

Code:

SELECT * into TestTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\ExamCenter.xls;HDR=YES;IMEX=1;', 'SELECT * FROM [user$]')

error:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

1
c#asp.netsqlsql-serverexcel-2010
can you share the actual code you are running? - No Idea For Name
read this article I hope it is helpful for you. https://stackguides.com/questions/338776/creating-a-sql-table-from-a-xls-excel-file - Manish Sharma
i have to create table based on excelsheet data structure, means columns of table decided based on excelsheet data. - Manish Mishra

1 Answers

0
votes

Please use the following link to find an example

Import Export example