PDA

View Full Version : Solved: Excel does not allow importing* accdb files



cactus
05-21-2009, 06:29 AM
Hi,

Im working with Excel 2007 and when i try to import data from an Access Database (also 2007), Ms Query does not allow to choose accdb extensions... only *.mdb.

Any ideas?

Thanks

cactus.-

Oorang
05-29-2009, 11:44 PM
I saw this (http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23821410.html) on Expert's Exchange:


Ok, I found this thing. Office 2003 has a regkey under
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\MS Access Database\Driver

On my machine driver was pointing to an old Office11\ DLL but I had to point it to the new Office12\ACEODBC.DLL

I hope this info helps anyone in the future