Access 2016 Database Engine Link

Provider=Microsoft.ACE.OLEDB.16.0;Data Source=C:\Data\Report.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";

AccessDatabaseEngine_x64.exe /quiet To install in passive mode (shows progress): access 2016 database engine

Provider=Microsoft.ACE.OLEDB.16.0;Data Source=C:\Data\MyDB.accdb;Persist Security Info=False; Provider=Microsoft

If you're just building a new application, consider migrating from Access to SQL Server Express (free) or SQLite. But for supporting existing Access databases in a mixed environment? ACE 2016 is your answer. Have a specific error message? Drop it in the comments and I'll help decode it. Extended Properties="Excel 12.0 Xml

AccessDatabaseEngine_x64.exe /passive Once installed, here are the most useful connection strings: