Solved

Transfer Access Table Data

Posted on 2013-06-17
2
385 Views
Last Modified: 2013-06-17
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
0
Comment
Question by:RobertStamm
2 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
Comment Utility
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
 

Author Comment

by:RobertStamm
Comment Utility
Where do I paste this code?  It have been a while....sorry.
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now