Extracting data from MBE

[CRoberts]

I am working on large project with quite of number of Access databases located at remote sites where their Access databases are in an MBE format. These files are being sent to me and, I suspect, are in a variety of MS Access versions.

What are the steps needed to convert these MBE back into a more accessible MDB format (I have an ETL to map to MDB)? As I may have a few hundred MBE files, is there a programatic solution to quickly and conveniently converting these files? Am I better off just writing a query to extract the data into flat files and having these remote site run these queries? Thank you for any help in this.

 

[jrbarnett]

I presume you mean MDE rather than MBE - being the compiled Access data.

Its not possible to convert an MDE back into an MDB, it just removes the source code for forms, reports and VBA modules.
Recovering this source code isn't possible as far as I am aware.

You can extract the data though into a new database - just use the linked table manager to connect to your MDE file to join the table and insert it into a new local database.
Alternatively, open it, press F11 to open the database window then use a copy and paste on each table to a new database.

Queries themselves can also be copied and pasted - but to make sense of them, all the original data has to be in the new database first.

John