Two Tables import selected data from one

[Lensmeister]

Hi all,

I have Access 2003 and I have two tables in it. I need to import/copy over selected data from one table (Station Data) to the other (tbl_Stations).

You can see from the attached image the tables the fields I wish to import into table tbl_Stations.

3-Alpha, TIPLOC1 thru 4 Easting and Northing.

Is there an easy way to do this? Or can anyone help on the way to go about it please ?

Thanks in advance.

 

[John Big Booty]

Have a look an Update Query, that should be able to do what you are looking for. Assuming that you have a field that can reliably link the data in both tables.

 

[Lensmeister]

I have tried googling and I found this. http://www.ehow.com/how_2019835_update-query-access.html

It didn't give me the results I wanted. What am I doing wrong?

 

[Lensmeister]

Problem solved.

I exported to Excel. Did a Vlookup. then imported as a new table and deleted the other ones out.

Thanks anyways.