Click here to Skip to main content
15,439,290 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
When executing this query it shows an error.
SQL
INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 8.0;Database=E:\Tirumalarao\Sheet1.xls;;HDR=YES','SELECT Eno,Ename,Date,DeptNo,Job,Comments,Sno FROM [Sheet1$]') 
SELECT Eno,Ename,Date,DeptNo,Job,Comments,Sno FROM  dbo.EMPLOYEE

Error:OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "The Microsoft Office Access database engine could not find the object 'Sheet1$'.  Make sure the object exists and that you spell its name and the path name correctly.".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
Posted
Updated 12-Mar-12 20:53pm
v2
Comments
Prasad_Kulkarni 13-Mar-12 2:51am    
post your code example
André Kraak 13-Mar-12 2:53am     CRLF
Edited question: Added pre tags

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900