Transfer Access Table Data

Experts,
I have two access tables and I need to transfer two fields of data from Table 2 into Table 1.

Table 1 is called 2012_PS
Fields...
PS_Name
GPS_Lat (currently no data)
GPS_Long (currently no data)

Table 2 is called PS_Butler_PS
Fields...
PS_Name
GPS_Lat (currently has data)
GPS_Long (currently has data)

I would like to copy all of the GPS data from Table 2 into GPS fields in Table 1.  
PS_Names match in both tables.

Can someone please assisst me with showing me how to do this.

Thanks,
Bob
Bob StammOperations ManagerAsked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
Update [2012_PS] as T1 INNER JOIN [PS_Butler_PS] as T2 ON T1.PS_Name = T2.PS_Name
SET T1.GPS_Lat = T2.GPS_LAT, T1.GPS_Long = T2.GPS_Long
0
 
Bob StammOperations ManagerAuthor Commented:
Where do I paste this code?  It have been a while....sorry.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.