Update Records in 1 table with data from 2nd table

[FeS2]

I have currently have 2 tables, 1 has 1500 records and the other 13000 records. Table 1 has a dozen fields that are not in table 2 and Table 2 has fields that are not in table 1. 1 field is identical on both tables and contains the same data. I can get a query to run against both tables that will show the data i want. What i need it to update table 1 with the fields it doesn't have with data from table 2. I am stuck at this point, i have thought about exporting the whole thing to excel to do it and then import it back to access, but would prefer not to do that. Please help.

 

[PHV]

Have you tried to build an UPDATE query in the Query Design Window ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Crowley16]

you can use the INSERT INTO statement for what you want...

basically, the syntax is:

INSERT INTO tblName SELECT field, field FROM tblName WHERE condition