|
Home > Archive > MS Access database support > June 2005 > Newbie Question: Copying A Record's Data From Multiple Tables In One Database to Another
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Newbie Question: Copying A Record's Data From Multiple Tables In One Database to Another
|
|
| No Spam 2005-06-30, 9:24 am |
| Greetings Access Users,
I have a database that has a record that I wish to copy from one
database to another. The table structures in the two databases are
identical. Here's the issue: the record's data is broken up into
about 10 related tables. Is there any hints or tips on the best way
of writing a query or some other solution to acheive this copy?
I have about 70 records to copy from one database to another, and if I
have to manually re-enter the data, it would take days.
Thanks a million in advance, any advice that solves this matter would
be a life saver!
Kevin
| |
|
| "No Spam" <nospam@earthlink.net> wrote in message
news:ohs7c115dg4nds1
2hv9n70627s9db9p9b6@
4ax.com...
> Greetings Access Users,
>
> I have a database that has a record that I wish to copy from one
> database to another. The table structures in the two databases are
> identical. Here's the issue: the record's data is broken up into
> about 10 related tables. Is there any hints or tips on the best way
> of writing a query or some other solution to acheive this copy?
>
> I have about 70 records to copy from one database to another, and if I
> have to manually re-enter the data, it would take days.
>
> Thanks a million in advance, any advice that solves this matter would
> be a life saver!
>
In your source database, create a link to you destination table (linked
table manager), then use an append query with the linked table as the
destination.
HTH - Keith.
www.keithwilby.com
|
|
|
|
|