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!
  • Students Click Here

*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

MS Excel-Approach Merge

MS Excel-Approach Merge

MS Excel-Approach Merge

I have a simple Approach database set up with such fields as user id, name, address, city/state, zip and pin number.
I also have an Excel spreadsheet with user id, original confirmation number and new confirmation number. I need to retrieve the mailing info from Approach database using the info from the spreadsheet and populate a form letter using info from both except the pin number. What's the easiest way to accomplish this?  

RE: MS Excel-Approach Merge

I would do it this way. Define a new table with the same fields as the Excel spreadsheet and join it to your other database on the "user id" field.

Import the spreadsheet into the new table. You can now put information from both of the databases into a form letter.

Sue Sloan

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