I have already run the upsizing wizard from my production Access 2010 .accdb database to create all the table structures and move the data on to our new SQL Server 2014. This included adding some PKs on the server which didn't exist in Access and some other clean up.

I have duplicated all the table structures to create a development version of the tables in their own database on the same server and am now trying to pull the data from the development version of the .accdb into the development database. (i.e., I don't want to run the Upsizing Wizard again from the Dev Access DB because of all the structure clean up that I don't want to do again.)

Using Right-click | Tasks | Import Data to get the Import and Export Wizard, when I click the drop down on Data source, I have an option for Microsoft Access (Microsoft Jet Database Engine) which doesn't recognize the .accdb format.

I've seen screen shots from various places on the web of the Import Wizard with a Microsoft Access (Microsoft Access Database Engine) option which does recognize the .accdb format.

Why would my Import Wizard be missing this data source option, and what can I do to resolve that?

Based on Aaron's suggestions, I checked the ODBC driver, and it appears to be the 64-bit version: enter image description here

If I explicitly run c:\windows\SysWOW64\odbcad32.exe, I get what must be the 32-bit version: enter image description here

I'm running 64-bit Office on a 64-bit Win7 installation, and I'd assume that SQL Server 2014 is 64-bit by default (I didn't install the server nor the SSMS on my machine).

It seems that the initial link Aaron provided addresses the exact opposite of what I'm trying to accomplish. That issue seems to be trying to explicitly use the 32-bit driver on a 64-bit system, while I seem to be stumbling into the 32-bit driver when I want the 64-bit. It does seem that there may be something wrong in the registry, as that question mentions, but I'm not comfortable enough to root around in there on my own, though I can certainly follow some instructions.

  • 1
    Is it possible you only have the 64-bit drivers installed, and need the 32-bit ones to work with Access? – Aaron Bertrand Sep 23 '15 at 15:53
  • @AaronBertrand - entirely. Where would I go to confirm this, and to find the 32-bit drivers if that is the issue? – FreeMan Sep 23 '15 at 15:56
  • See this, this and this. – Aaron Bertrand Sep 23 '15 at 16:06
  • @AaronBertrand, thanks for your suggestions. I've looked at those links and they've caused more questions than answers. I've updated the OP with some additional info. – FreeMan Sep 23 '15 at 17:10
  • Sorry, really don't know. Last time I touched Access was I think Access 97. – Aaron Bertrand Sep 23 '15 at 17:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.