Access Database Engine: Required for ETL+ Excel, .csv & MS Access
- Cortlandt _
ETL+ requires that the Microsoft Access database engine 2016 is available as a driver in order to read / connect, as data sources, to MS Excel workbooks, .CSV, text, and MS Access databases.
Manually Download Installer
ETL+ should download and run this installer for you.
In some cases you may need to download and re-install the required MS Access Database Engine software and reboot your Windows server
Download Required Software
https://www.microsoft.com/en-us/download/details.aspx?id=54920
How to Verify the Driver is Installed
Method 1: Control Panel > Programs and Features
Method 2: Installer/Uninstaller: AccessDatabaseEngine_X64.exe
ETL+ should download AccessDatabaseEngine_X64.exe (or 32 bit version) in the same folder as DataSelf ETL Plus.exe
Microsoft Docs
https://support.microsoft.com/en-us/office/access-2010-database-tasks-268acfed-2484-4822-acb3-c30e58045588#bmimportexcel See heading “Import an Excel worksheet as a table in a new database”.
Import Spreadsheet Wizard. The instructions refer to a “Import Spreadsheet Wizard”.