×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Need to pull some info from other database to new one

Need to pull some info from other database to new one

Need to pull some info from other database to new one

(OP)
I have a "Test" table that I have reworked and now need to take the live data table and update the Test table with... I have reworked the new table but need to retain some info..

Each table uses a unique Id of a "Job Number"...

I need to take the "good delivery date" info from the live table and put that info into the test table...

Can anyone help ???

Thanks!
Mitch

RE: Need to pull some info from other database to new one

Hi Mitch, I would suggest to import the whole table in to the good database as a first step. From there build an update or append query to transfer or add your data. As a safety you might even make a copy of the good table and try your action query or queries there first.

Gord
ghubbell@total.net

RE: Need to pull some info from other database to new one

(OP)
Gord,

A little twist in this issue.

My table that I want to update is called tblOrderLog and the other table that has the info is called tblDelSked....

They both have a field called DelDate. I want to use the tblDelSked to "update" the proper DelDate to the tblOrderLog table... The tblDelSked only has 250 records and the tblOrderLog has 14,000.. So I need to use the comman Primary Key called JobNumber to do this..

Does this make sense ???

RE: Need to pull some info from other database to new one

Sure Mitch,
Once again, don't forget a backup of the table in the event of...

For 250 records as a one shot thing I'd do it this way
Start with a select query based off of the two tables, DelDate field from the tblDelSked, and DelDate from tblOrderLog, maybe the JobNumber from either just for fun:

"Show me all the records in tblDelSked and only those that match in tblOrderLog (joined by the JobNumber)".Go to datasheet view and check your results. If all is good you should only see your 250 records.

Copy the entire column of your tblDelSked DelDate. Select the tblOrderLog DelDate column. Paste. Hopefully it will accept it. and that's it. If it works its fun to watch and you do get the option to not paste if things don't look right.

Gord
ghubbell@total.net

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close