• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4358
  • Last Modified:

Excel 2007 - Unrecognized Database Format

I am attempting refresh a data table in Excel (2007) via a data connection to an ACCDB. The database and the original spread were built on someone's computer who previously used Office 2003. My computer was Office 2007 loaded day 1 when I began using it.
When I go to refresh the tables linked to the database, i get an error message "Unrecognized Database Format 'T:\My Documents\Database.accdb'. I notice when I go to add a database connection, the types of files it offers are only "mdb", not "accdb".

What could be my problem and how can I go about fixing it?
Please ask for additional details that would better describe my issue.

Thanks,
Chris
0
ctownsen80
Asked:
ctownsen80
1 Solution
 
pcelbaCommented:
It seems you've converted the mdb database into the Access 2007 accdb format but you are still using the old Jet engine for data connection. You have to use the new ACE DB engine to access accdb files. It means you have to either define new DSN for data access or you have to select appropriate ODBC driver (version 12).

0
 
sameer2010Commented:
Yes. use this connection string:
Provider=Microsoft.Ace.OLEDB.12.0
0
 
ctownsen80Author Commented:
pcelba: ... Thank you, ... Can you tell me exactly how to go about doing that? I'm not very keen on the steps and procedures needed to do that.
Thanks,
Chris


Thanks you as well sameer2010
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
ctownsen80Author Commented:
I know I go to Settings >> Administrative Tools >> Data Sources {ODBC) .. from there is where I need more support....

Thanks again...
0
 
pcelbaCommented:
So, from here press Add and select Microsoft Access driver (*.mdb, *.accdb) version 12.00.6423.... and press Finish.  On the next window select the database and assign the Data Source Name and save the newly defined DSN.

In Excel you have to update connection properties - simply change DSN to the newly defined one.
0
 
pcelbaCommented:
It, of course, depends how you are accessing data from Excel. If you click on Data ribbon in Excel and then "Get External data from Access" then you don't need to define DSN but you can select Access database directly.

DSN is used e.g. in Microsoft Query.
0
 
puppydogbuddyCommented:
Just in case the problem still is not solved, you should look into the following hotfix for MS Access 2007.  One of the items fixed is the "unrecognized database format........"
                        http://support.microsoft.com/kb/943249
0
 
ctownsen80Author Commented:
Worked! Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now