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.