Hi @Pat Mesop ,
To fix this error, first thing first, install “Microsoft Access Database Engine 2016 Redistributable.”
And then also check the version of Excel and SSMS. They need to be same, like 32 vs 32 or 64 vs 64
SSMS is a 32 bit client, if your Microsoft Excel is 64 bit. you may need to install the 64 bit version of the Microsoft Access Database Engine 2016 Redistributable and try opening – the 64-bit “SQL Server Import and Export Data” directly. Go to Start Menu -> Microsoft SQL Server 2012( your SQL server version) -> SQL Server Import and Export Data (64-bit)> Open the application and try to import data using the “Excel 2016” option, it should work fine.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".