January 30th, 2007, 03:42 PM
Microsoft Access MDB
I have an old MDB that I pulled off a backup tape, can I merge that with my current MDB that is missing the old data? If so, how would I do this?
January 30th, 2007, 04:32 PM
Yes...you will have to use an append query.
What version of access are we talking about??
How people treat you is their karma- how you react is yours-Wayne Dyer
January 31st, 2007, 10:31 AM
There are a variety of ways......... as Morgana~ says, what versions of Access are we talking? (like the old stuff and the new stuff)
"append" woulkd be a classical approach, but depending on the situation, perhaps creating the backed up data in a new DB and running an update query might suit?
February 3rd, 2007, 05:38 AM
Originally Posted by Info Tech Geek
I haven't had to do this, but you can right-click | Import in the databases window. I'd expect you can import your old tables and either have them appended automatically or just copy/paste data.
Backup both and play around a bit.