How Do Perform An Update Query From One Table To Another?

bogushs

Registered User.
Local time
Today, 11:58
Joined
May 4, 2005
Messages
27
Hi there.
Does anyone know how to use an update query to copy some records from one table into another?
I have table1 which has all the contact details and what I would like to do is work out a process for importing records from an excel spreadsheet.
What I have so far is as follows:

1. In access go into the queries tab and select update query
2. Open both table1 and table2
3. Drag the fields to be updated (table1)
4. In Update to select [table2].[table2 column name]

When i run this nothing appears to happen. 0 records are appended.
Does anyone now how to go around this with another solution or should I be using other SQL methods?

All comments much appreciated
Thanks
 
If you to add whole records you need an append query. Update queries are for changing fields in existing records.
 

Users who are viewing this thread

Back
Top Bottom