0
Answer

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

jayakrishnan Morayur

jayakrishnan Morayur

13y
2.5k
1

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