combining tables

[Guest]

Hi,

I have two tables with fields that are the same (i.e. Id, Date, Tmax, Tmin,
precip). Records in each table are unique and do not match with eachother. I
would simply like to add the tables together to make one table with all the
records. How do I do this??

 

[Guest]

Create a simple select query that takes all the fields from table2. Change
the query type to an append query (select this from the query menu) and
select table1 as your destination table. Run the query and answer yes to the
confirmation prompt.

 

[gls858]

Create a simple select query that takes all the fields from table2. Change
the query type to an append query (select this from the query menu) and
select table1 as your destination table. Run the query and answer yes to the
confirmation prompt.

:

Just an added thought. I would take a copy of the table before the append
just in case. You can delete the copy after you're sure that the append was
successful.

gls858

 

[Guest]

This is the first that I was 'told' to start with table 2 and then appending
to table 1. Is there any reason to keep the append querry after the tables
are added together?

 

[Vincent Johns]

This is the first that I was 'told' to start with table 2 and then appending
to table 1. Is there any reason to keep the append querry after the tables
are added together?

No; it will have done everything you need by that time.

Actually, if the fields really do have the same names, formats, &c., and
no conflicting key values are present, you probably don't need a Query
at all. After backing up your database file, just copy one of the
Tables in the Database Window, select "Paste", select "Append Data to
Existing Table", and append the data to the other Table.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.