Microsoft.ACE.OLEDB.12.0" for linked server "(null) error
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)".