Importing certain fileds into existing data base

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I dont know much about access but I maintain DB of employees in my company,
and I need to import some additional information for almost each employee. I
know how to import information for new employee, but I dont know how to do
that for those already existing in DB when DB is set up not to allow double
records, like employee ID #. Please help, I dont wanna do that manualy for
each employee
 
sdj78 said:
I dont know much about access but I maintain DB of employees in my
company, and I need to import some additional information for almost
each employee. I know how to import information for new employee, but
I dont know how to do that for those already existing in DB when DB
is set up not to allow double records, like employee ID #. Please
help, I dont wanna do that manualy for each employee
Click to expand...

Import into an empty work table first. Then use an update query for existing
records followed by an append query for the new ones.

If you can link to your external source rather than importing then the link can
fill the role of the work table.
 
Back
Top