SQLTeam.com | Weblogs | Forums

Import excel error

Since a upgrade to SQL went in I get this error just doing a simple Import to Excel?

SSMS version 15.0.18
SQL 2017

Any help would be appreciated

You need to install that missing provider

Is there something that I need to uninstall first?



can you download and install the 64 bit version of it instead of 32 bit and see what happens?

see this thread: https://social.msdn.microsoft.com/Forums/en-US/c159dec1-1b83-45e3-8493-9d3a8fbec4c2/microsoft-access-database-engine-2016-redistributable-wont-install-due-to-64bit-component?forum=officegeneral

You can install the 32-bit drivers, but you have to run the install manually with the /quiet parameter. I would recommend installing the 2016 version instead of the 2010 version. If you must install the 2010 version then the flag is different - I think it is /passive.