Migrating Data....not as easy as I thought

S

stevescotthome

What’s the best way to move data from one old MDB into a new MDB?...when I do
a data import Access-to-Access it re-creates the entire table appending a “1â€
to the end. So if before I had “Tbl_Issues†I now have “Tbl_Issues†and
“Tbl_Issues1â€â€¦same thing with queries, etc

I’ve tried exporting to XML, but it seems like I can only do one table at a
time (and theres TONS)….and sometimes there’s an illegal XML character and it
wont let me import it :(

What happened was that I was given two MDB files to migrate into one...now
that I have compelted that I need to take the latest versions of both of
those and move the data into my merged version...not as easy as I thought

Suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top