How to get data out of Access MDE files?

[access22]

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...access_otn.htm

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



Thanks a lot!

[RuralGuy]

I take it you own Access 97? Can you import the tables from those MDE's into a new blank mdb?

[access22]

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!

[RuralGuy]

That's great! Are you ready to follow the link in my sig and mark this thread as Solved?