Excel 2003 to Access 2007

  • Thread starter Thread starter IgorM
  • Start date Start date
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
 
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...)
 
Back
Top