Solved

Transfer Access Table Data

Posted on 2013-06-17
2
396 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
ID: 39254131
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
ID: 39254222
Where do I paste this code?  It have been a while....sorry.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

919 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

12 Experts available now in Live!

Get 1:1 Help Now