Click here to Skip to main content
15,905,508 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
When executing this query it shows an error.
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)".
Updated 12-Mar-12 20:53pm
Prasad_Kulkarni 13-Mar-12 2:51am    
post your code example
André Kraak 13-Mar-12 2:53am    
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