How to populate one table with data from another?

[daveofgv]

Hello everyone -

I have a quick query question.

If I have a table (table1) with a so many columns, however, 3 of the columns are "name", "box_number", "storage_location", which there are about 5000 or so records with names already in there - and I have a list of 500 of those names (table2) with box_number and storage_location already defined - how can i use a query to fill in table1 with the box_number and storage_location instead of doing it one by one?

Hope this makes sense.



I appreciate your help

daveofgv

[June7]

Use an UPDATE query. Access Help has guidelines on how to do this.

[daveofgv]

Thank you for the reply.....

I am in the query design.... I added the fields I want to update in Table1 and Table2 (that has the data)....

the row Update To I need to write the expression.... What expression do I write to update the rows?

Basically, I need, if name in table2 equals name in table1 then box_number and shelf_location in table2 insert into table 1......

Thanks

[daveofgv]

Thank you.... I think I figured it out:

Field: box_number
Table: Table1
Update To: [table2].[box_number]
Criteria: [Table1].[name]=[Table2].[name]

I ran the query and appeard to work.

I found it on http://www.techonthenet.com/access/queries/

This site has a bunch or query help

Thanks to June7 for guiding me to the update query.