Append or Update query

[Guest]

Hi guys! I need some help in updating an employee table in Access 97. I get an Excel file that contains about 10 fields of information about employees. I currently have a table in Access, table 'A', that was originally created from importing that Excel file some time ago, but now it contains about 32 fields of information. What I need to do on a regular basis is update the table in Access with the new information in the Excel file. I have imported the Excel file into Access table 'B' and can Append, Update, then Delete employees that no longer work for us. The trouble I am having is updating the current employee’s information, like job title, salary, manager, etc. Can someone please help me with this? If I have to rebuild, that is fine
Thank you!!

 

[[MVP] S. Clark]

You would use an Update query, to update records in A, from B.

An append query would duplicate the records.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Hi guys! I need some help in updating an employee table in Access 97. I

get an Excel file that contains about 10 fields of information about
employees. I currently have a table in Access, table 'A', that was
originally created from importing that Excel file some time ago, but now it
contains about 32 fields of information. What I need to do on a regular
basis is update the table in Access with the new information in the Excel
file. I have imported the Excel file into Access table 'B' and can Append,
Update, then Delete employees that no longer work for us. The trouble I am
having is updating the current employee's information, like job title,
salary, manager, etc. Can someone please help me with this? If I have to
rebuild, that is fine.