Linking two tables (1 Viewer)

[Hann]

Morning out there,

I have two tables in a DB which contain data about mobile telephones. The column names are similar. To assemble all of that in one table I tried to link the tables, or copy them into each other. Never worked out.

So could anyone give me a hint how to overcome this and attach the data of one table to the other.

There are no similar entries in both tables.

Hann

 

[Pat Hartman]

You can append the contents of one table to the contents of the other. Choose which table will be the one to hold all the data then make a query that selects the appropriate columns from the other table. Change the query type to Append. Select the table you want to append these records to. Then choose the "Append To" fields. Run the query.

 

[Hann]

Worked out nicely, Thank you.