Friday, July 31, 2015

SSMS Import and Export Wizard: 32 or 64-bit?

Ever got that annoying error?
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Good chance you're running the 32-bit version of the Import and Export Wizard and want to import an xlsx-file. You could solve it by saving the file as an xls-file (the Excel 97-2003 Workbook version). Or you can also run the 64-bit version of the wizard.

If you right click a database and select Tasks > Import Data… you automatically start the 32-bit wizard.

Start >> All Programs >> Microsoft SQL Server <version> >> SQL Server <version> Import and Export Data will start the 64-bit version of the wizard.