Append or Update Query?

[Channell]

Hello,

Ok, so here is my task. I have my Access Database pretty much set to what I
need it to do (with the help of so many of you. Thank you all). Now, I have
access to certain Oracle Tables through the company I work for. I need to
pull information out of these Oracle Tables (regarding my employees) and
insert it into my access database. Now, I have records created daily for my
employees in my ADB. There are certain fields that are left blank that I
need automatically populated with information from an Oracle Table.

I have already linked the Oracle Table to my ADB. I just need help with
getting the information from the Oracle Table into my employee work table. I
would use the date and an actual Employee ID Number provided by the company
(Not a primary Auto Number) as criteria as far as what records I need updated.

How do I go about this? I know append is to add records, but I am not
looking to add records, I am looking to populate existing blank fields.
Thank you so much. I am incredibly thankful for all the help rendered on
this website.

-Scott Channell

 

[KC-Mass]

Hi,

Assuming you already have the employeeID, LastName, FirstName, etc in
an Access tableand you want to add from Oracle the PositionTitle, PayRate,
Appointed Date or some similar data items then you want an update query
where the Access and Oracle tables are joined on a common field
(employeeID?).

Regards

Kevin