jayakrishnan Morayur

jayakrishnan Morayur

  • NA
  • 193
  • 258.2k

Microsoft.ACE.OLEDB.12.0" for linked server "(null) error

Aug 26 2011 7:29 AM

INSERT INTO CSVTest select * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 
'Excel 12.0;Database=D:\b.xls;HDR=YES', 'SELECT * FROM [Sheet1$]')



        The following error occur on above line

Msg 7399, Level 16, State 1, Line 4
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 4
Cannot get the column information from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".