Importing certain fileds into existing data base

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sdj78 - 26 May 2007 13:00 GMT

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

Reply to this Message

Rick Brandt - 26 May 2007 13:12 GMT

> 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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message