Forum Discussion
Opening a .mdb file
Hi. I havea .mdb file that I need to open. When I try to open it using MS access 2003 or 2007, I get "unrecognized database format.." error. I do not know what version was used to create that file. I...
whether the db was created in Old or New version of MS Access, you can view the data using Excel.
Use Data->Get Data->From Database, and select your .mdb.
Use Data->Get Data->From Database, and select your .mdb.
arnel_gp
I believe modern versions of Excel have the same limitations as Access. Anything created before A2000 cannot be opened. Just tested with valid A95 & A97 files
However, if saved as a .txt file you can import it (tested successfully). My advice is:
1. Save a copy as a text file
2. Open in Excel and import as fixed width. Set suitable break points. You will then see much usable data (and lots of junk). For example, see attached screenshot
