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

Copy and move Access 13 database on laptop to pc with Access 13 0
Convert mdb to accdb 4
Column order chages when data is imported from Excel 1
CCur function in 2003 and 2007 0
Access 2007 1
Using MS Query with Excel and Access 2007 3
How do you connect Word 2003 to Access 2007 accdb database??? 3
Please Help - Access 2007 8

Top