Using MS Access Databases on Windows Shared Servers

Note: 

You may need to contact us to determine if the driver is present on the Shared Hosting server where your website is located.

Please see the below conditions in order to use the Microsoft ACE OLEDB.4.0 driver.

If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.

If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”

If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:

File Type (extension) /  Extended Properties

Excel 97-2003 Workbook (.xls) / "Excel 8.0"
Excel 2007-2010 Workbook (.xlsx) / "Excel 12.0 Xml"
Excel 2007-2010 Macro-enabled workbook (.xlsm) / "Excel 12.0 Macro"
Excel 2007-2010 Non-XML binary workbook (.xlsb) / "Excel 12.0"

If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to:
“Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”

If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to:
“Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”