merge two tables

  • Thread starter Thread starter Lila
  • Start date Start date
L

Lila

I have a database that has a list of 1000 contacts with about 80 fields for
each contact.

I recently received a spreadsheet (that I imported into a new table) from
someone else that has updated information for about 300 of these contacts,
but the information they sent only had about 6 fields.

What kind of query can I write that will push all of the information from
the new table into the old table without loosing any information from the
old table. I've thought about a union query, but dread having to type in
all 80+ fields from the old table into the query.

Thanks,
 
That is a lot of fields for a database table.

You do not have to type the 80 fields just select them in design view and
then go to SQL view to edit.

But there is no need for a union query. Add the fields to your 80 field
table. Create a select query and join the two tables on common fields.
Review the output of the select query - are most of the records selected?

Then change the query to an update query and run, updated the added fields.
 
What do you mean when you say "add the fields to your 80 field table"? The
fields already exist in the table.
 
The update query worked, thanks!

Lila said:
What do you mean when you say "add the fields to your 80 field table"? The
fields already exist in the table.

fields
Click to expand...
 
Back
Top