Hi there I have a table which I would like to create an Excel file from. My query is as follows:
insert into OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=D:\testing.xlsx;',
'SELECT * FROM [Sheet1$]')
select * from PAYHISTTEMP
My error is:
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.
What I have tried:
insert into OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=D:\testing.xlsx;',
'SELECT * FROM [Sheet1$]')
select * from PAYHISTTEMP
My error is:
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.