Is it possible to combine 2 tables into one?

[Collins]

A coworker of mine is trying to combine the table from one database with the table of another database. Is that possible? The information I've been able to find is by using a query and that's not what they want. They want all the fields in the one table added to the fields in the other table. The unique ID matches each record in both tables if that's useful.

[June7]

Can they set a link to other table? Build a query that joins the datasets.

If they want to actually copy the data (why?) that is different.

[Collins]

Can they set a link to other table? Build a query that joins the datasets.

If they want to actually copy the data (why?) that is different.

OMG June 7 are you the only person on this forum? You're the only one that ever answers my questions. You have got to be getting sick of me. They actually want the data (the records) on one table merged with the records of the other table. Basically he has a table in one database with 1 2 3 fields and a table in another database with A B C fields. He wants a table with 1 2 3 A B C fields in it. The unique ID for the records in both table match each other.

Is that making any sense???

[June7]

Easiest approach probably is to set a link then do whatever is necessary with the data.

How much data? Is this a one-time event? Are they both Access db?

[Collins]

Easiest approach probably is to set a link then do whatever is necessary with the data.

How much data? Is this a one-time event? Are they both Access db?

They're not huge. One is 10,412kb and the other is 8,448kb. Both are Access. It would be a one time deal. We're talking 318 records.

[June7]

Can you link to the other table? Create the fields in the destination table. Then run an UPDATE sql action. Then remove the table link. No code necessary.

[John_G]

Another approach you could take is a make-table query. Join the two original tables on the unique ID (it doesn't matter if they are linked or not), include the fields you want, (ID only once), then specify a destination table name. When you run the query you will get the new table with all the fields.

[June7]

John_G, they still need to set a link to table in other database.