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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.