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...
I do not know which version of office you're referring to, but I tried Excel 2003> Data> Import External Data> Import Data. Then it asks credentials to connect to the database with username Admin set as default with blank password. When I click test connection, it shows "unrecognized database format" error. It worked when I changed the extension to "txt" instead of "mdb" and imported it successfully, but the data are not organized. It spreads data in a number of columns.
You cannot import from the MDB file as it is not a valid MDB database file
As already stated, saving a copy as a .txt file will allow you to import it into either Excel or Access using the fixed width option.
The data is organised but the usable data is split into several fields as it would have been initially (see my earlier screenshot)
There are almost 60 fields, most of which you can probably delete after inspecting them yourself
