Updating a Pre-existing Access Table With Info From Excel 1

[CuckooNut]

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!

 

[Remou]

I suggest you link the excel sheet as a table and run an update query to update the existing data and append query to add new employees. You may also wish to look at forum705.

http://lessthandot.com