Importing certain fileds into existing data base

[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

 

[Rick Brandt]

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

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.