Solved

Transfer Access Table Data

Posted on 2013-06-17
2
428 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 48

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

705 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