Monthly Archive: January 2021

Types of microsoft.ace.oledb Driver Errors: SELECT * FROM OPENDATASOURCE(‘Microsoft.ACE.OLEDB.12.0’, ‘Data Source=D:\tmp\a2.xlsx;Extended Properties=EXCEL 12.0’)…[Sheet1$];ORSELECT * FROM openrowset(‘Microsoft.ACE.OLEDB.12.0’, ‘EXCEL 12.0 Xml;Database=D:\tmp\a2.xlsx’,’select * from [Sheet1$]’); Error -1: The OLE DB provider “Microsoft.ACE.OLEDB.12.0” has not been registered. Msg...