INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

Updating a Pre-existing Access Table With Info From Excel

Updating a Pre-existing Access Table With Info From Excel

(OP)
Hi,

I "inherited" a database that our company has been using for several years to track all of our work flow, production, etc.  The database includes contact information for all of the company's employees, past and present.  However, most of the contact information is outdated, and I need to update it and keep it current.  The problem is, we are a virtual, distributed organization, and our database is only accessible to a few of us.  This means that to get everyone's current info, we have to use an Excel spreadsheet.  The columns in the spreadsheet match up with the fields in the database table.  What I need to do now is find a way to import the information from the spreadsheet into the database in such a way that employees whose info is already in the database have their records updated, and employees who are not yet in the database have their records added.

Any suggestions on the best way to go about it?  Thanks in advance!

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!

Resources

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