If you use 32-bit application, and meet error message “Provider cannot be found. It may not be properly installed”, or “Data source name not found and no default driver specified”, Please download and install Microsoft Access Database Engine 2016 Redistributable 32 bit version (AccessDatabaseEngine.exe).
This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access (*.mdb and *.accdb) files and Microsoft Office Excel (*.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server.
Update: Now our Access tools can work without Microsoft Access installed, and no need to install “Microsoft Access Database Engine”, and can run on Windows/Linux/macOS.
And our Excel tools can work without Microsoft Excel installed, no need to install “Microsoft Access Database Engine”, run on Windows/Linux/macOS.
Find more database tools.