SSMS Import of MS Access accdb external component has thrown an exception (System.Data)

[RichardJPWilliams]

I've been using SQL Server Management Studio for some time to import tables from MS Access into SQL Server.Now I get an errorExternal component has thrown an exception. (System.Data)when I choose an Access database to import from. This worked only a couple of weeks ago, any ideas what might have changed?I only have Office 2016 installed. The full error is:=================================== ===================================External component has thrown an exception. (System.Data)Program Location:at System.Data.OleDb.DataSourceWrapper.InitializeAndCreateSession(OleDbConnectionString constr,

Continue reading...