Microsoft access database engine 64 bit install#
In a different case, that is the scenario where your PC has SQL Server Database Engine installed on it along with SSMS, then you will need to install and use the 64-bit version of the Microsoft Access Database Engine 2016 Redistributable. Scenario 2: On a PC with both SSMS and SQL Server Installed In case you are using SSMS on your PC without a SQL Server Database Engine installation on it, then you will need to install and use the 32-bit version of the Microsoft Access Database Engine 2016 Redistributable, that is the file with name “accessdatabaseengine.exe”, since the SSMS process that reads from Excel files, is a 32-bit process. Scenario 1: On a PC with SSMS Installed but without SQL Server Installed
So, you can either download and install the 32-bit version of Microsoft Access Database Engine 2016 Redistributable (file name “accessdatabaseengine.exe”), or the 64-bit version (file name “accessdatabaseengine_X64.exe”).
Now, when you visit the above download link and right after you click on the “Download” button, you are presented with 2 options. To this end, the driver you are missing, is actually the Microsoft Access Database Engine 2016 Redistributable. So, indeed, as the above error message suggests, you are missing certain drivers in order to be able to read from Excel files (version 2007 or later – xlsx file format). The reason you get the above error message, is because you need to install the necessary drivers, in order for SSMS to be able to properly read the Excel file. via SQL Server Management Studio, also known as SSMS) and especially when trying to import data from an xlsx Excel file, that is a more modern Excel file format (Excel 2007 and later) than the old xls file format (Excel 2003 and earlier).
In most of the cases, you might get the error message, when trying to import data from Excel to SQL Server (i.e. Importing Data from Excel to SQL Server via SSMS In this article, we will be discussing about the error message and how you can easily resolve it.
0 kommentar(er)
