Transfer Data between Tables?

[bxjwn9]

I have created a database with 2 tables. I need to transfer data from one to the other. There is one field that is common to both tables. Please help me. Thanks in advance.

 

[KenHigg]

Use an append query.

And maybe look here:

 

[bxjwn9]

Thanks Ken. I don't think i phrased my question correctly. Let me try again.

I have 2 tables:

1st Table = Name , Age , Weight , Height , Skin type
2nd Table = Name , Location , Sex , Age , Weight , Height , Skin type

The 1st Table contains data in all 5 the fields while the 2nd Table only has data for Name , Location & Sex. I'm trying to transfer the 4 Fields (ex. Name) in the 1st Table and update the 2nd Table using the Name as the unique field.

Hope you can make sense of this. Thanks in advance.

 

[KenHigg]

Sounds like you simply need to create an append query and map the fields in the append from table to the appropriate fields in the append to table...


ken

 

[bxjwn9]

The Append just adds new records to my table. I need to update the existing records in the 2nd Table using the Name field as the link between the Tables. Sorry if i sound confusing.

 

[KenHigg]

Hum... Ok. Then you simply need to create an update query. In the query build bring in both tables and link them on the common field. Then bring down the fields from the table you want to update to. And then on the 'update to' row select the appropriate fields from the table you want to update from...


ken

 

[bxjwn9]

No luck Ken. The Update Query seems to only allow you to update based on a value entered in the "update to:" column. It doesn't prompt you for a Table name like the Append Query does.

 

[DJkarl]

No luck Ken. The Update Query seems to only allow you to update based on a value entered in the "update to:" column. It doesn't prompt you for a Table name like the Append Query does.

You need to use an update query, you can enter [TABLENAME]![FIELDNAME] into the update to field and it will update appropriately.

 

[Simon_MT]

Why do you need two tables?

Simon

 

[KenHigg]

Post me a sample db with the two tables and some data in them and I'll build it for you...


ken

 

[bxjwn9]

Eureka!!!! Thank you all. Much appreciated.