Error occurs in SQL Server Import/Export Wizard with .xlsx files (Excel 2016/2019/365).


Recommended solution (2026):


1. Download Microsoft Access Database Engine 2016 Redistributable:

https://www.microsoft.com/en-us/download/details.aspx?id=54920

- Choose x64 (64-bit) or x86 (32-bit) to match your SQL Server bits.

- If mismatch exists, install both with /passive /quiet flags or use compatibility mode.


2. Install it (may require closing SSMS/Excel first).


3. Restart Import Wizard.


4. Data Source → Select "Microsoft Excel 2007-2010" (*.xlsx) — even for newer Excel files.


5. Browse to .xlsx file → Next → Sheets/tables appear → Proceed with import.


This uses ACE.OLEDB.16.0 driver, compatible with modern Excel formats and SQL Server 2016–2022+. Avoids ISAM error in most cases.


Alternative if issues persist: Save Excel as .xls (older format) or use SSIS with script task for import.