Excel 2003 to Access 2007

I

IgorM

Hi

I'm trying to create a local qube using Excel 2003 (this feature has been
removed in Excel 2007). Thus, I'm trying to connect from Excel 2003 to
Access 2007 .accdb file. How can I do that? When I click Data, Import
External Data > New database query and select Ms Access and then navigate to
file I get a message that .accdb is unrecognized database format.

Kind regards
Igor
 
D

Douglas J. Steele

Since Excel 2003 was released before the accdb format was defined, I don't
believe it's capable of reading that file format.

Can you work with an MDB file instead? (Access 2007 is fine with them...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Dumb question alert! What program to use? 0
Excel data vs Access database 3
Access Lock File .LACCDB / Now shows as a notepad file 0
HELP: Not able to generate query from excel for access 2007 1
Access 2003 and excel 0
Convert mdb to accdb 4
Column order chages when data is imported from Excel 1

Top