How to get data out of Access MDE files?

[d***@yahoo.com]

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]

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

Post by d***@yahoo.com
Dear Experts,
I have an application that I've used for years
that runs on Access under the covers. Help shows
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
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]

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.

Post by d***@yahoo.com
I have an application that I've used for years
that runs on Access under the covers. Help shows
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
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?

[d***@yahoo.com]

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]

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