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

Question

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)".

read this article I hope it is helpful for you. http://stackoverflow.com/questions/338776/creating-a-sql-table-from-a-xls-excel-file — Manish Sharma
– Manish Sharma, Commented Jul 23, 2013 at 10:06
i have to create table based on excelsheet data structure, means columns of table decided based on excelsheet data. — Manish Mishra
– Manish Mishra, Commented Jul 23, 2013 at 10:12

arj.N · Accepted Answer · 2013-07-23 10:00:54Z

0

Please use the following link to find an example

Import Export example

answered Jul 23, 2013 at 10:00

arj.N

11 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Manish Mishra Over a year ago

i know these thing, my concern is i have excel with data and based on that data at run time create a table based on excel sheet data structure and import data.

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related