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?
Printable View
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?
Yes...you will have to use an append query.
What version of access are we talking about??
MLF
Hi, ITG
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?
:)
Quote:
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.:)