How to import data from Access
.accdb file to SQL Server? What should I choose in SQL Server Import and Export Wizard?
Suppose we choose OLE DB Provider for SQL Server Integration Services, then if that is a correct direction, what should be choose next from the following window? What to type in fields
Data Source and
Location, which mean more or less the same?
I followed instructions described here:
Easiest way to import access db (.accdb) into SQL Server 2016?
I have installed
Microsoft Access Database Engine 2010 Redistributable
However I was hopeless in seeing
Microsoft Office 12.0 Access Database Engine OLEDB
If I choose Data Source as
Microsoft Access (Microsoft Access Database Engine) I end up getting error message the one shown on picture below. Moreover I think that this data source is tailored for files mdb, not accdb.