How to get data out of Access MDE files?

dba...@yahoo.com

unread,

Apr 23, 2010, 3:37:50 PM4/23/10

to

Dear Experts,

I have an application that I've used for years
that runs on Access under the covers. Help shows
a reference to:
Access 2002 Desktop Developer's Handbook

It was a self contained application.
All I have are the two MDE files.
And they are full of data now.
The app requires a login.

I want to export this data into another database.

How can I get the table structures and the data
out of the MDE files?

A new version of Access?
Sql Server?
.NET?
A data conversion tool?

Oracle says that if they have the XML file
with the table structures, they can export
the data:

http://www.oracle.com/technology/obe/hol08/sqldev_migration/msaccess/migrate_microsoft_access_otn.htm

Is there a way to get the XML file
from the MDE file?

Thanks a lot!

Malek

unread,

Apr 23, 2010, 4:59:01 PM4/23/10

to

Hi,
if you got sql server, you can use integration services to export your data

"dba...@yahoo.com" wrote:

> Dear Experts,
>
> I have an application that I've used for years
> that runs on Access under the covers. Help shows
> a reference to:
> Access 2002 Desktop Developer's Handbook
>
>
> It was a self contained application.
> All I have are the two MDE files.
> And they are full of data now.
> The app requires a login.
>
>
> I want to export this data into another database.
>
>
> How can I get the table structures and the data
> out of the MDE files?
>
>
> A new version of Access?
> Sql Server?

> ..NET?

> A data conversion tool?
>
>
> Oracle says that if they have the XML file
> with the table structures, they can export
> the data:
>
> http://www.oracle.com/technology/obe/hol08/sqldev_migration/msaccess/migrate_microsoft_access_otn.htm
>
> Is there a way to get the XML file
> from the MDE file?
>
> Thanks a lot!

> .
>

Paul Shapiro

unread,

Apr 23, 2010, 6:04:48 PM4/23/10

to

Are the two mde files a) the frontend db with code, forms and reports and b)
the backend db with all the data? You don't need to run the frontend
application to get the data. If the data is in the 2nd mde, try opening that
one. If it is password protected, or if it has Access security, then you
have to either break the protection/security or find the password. There are
companies that have offered services to get data out of protected databases,
and some of them have had good reputations for years. I haven't used any,
but I've seen only good recommendations for
http://www.pksolutions.com/index.htm.

<dba...@yahoo.com> wrote in message
news:d4b85da6-1564-4ecd...@y6g2000prk.googlegroups.com...

dba...@yahoo.com

unread,

Apr 29, 2010, 12:06:34 AM4/29/10

to

Ok, here is what worked:

There are two files.
One mde had all the forms and code, etc.
The other had all the data.

I went to someone who had Access 2003 or 2007.
That allowed me to open both files.

When I opened the forms and code, it displayed
the same way as my application worked.

By opening the data file, I was able to see all my data!
Then I was able to save it to an excel file.
Yeah!

BruceL

unread,

Apr 29, 2010, 4:56:59 PM4/29/10

to

One trick that sometimes works is create a new database and just
import the tables from the MDE.