Please help with creating excel file from query results

See more:

SQL

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.