Web Development

General discussion


Find & update new entry with same info.

By bambamz ·
I have a ACCESS 2002 Db and an excel document with these same fields on them.

SSN NAME DateofLetter 35dayexpire Address DateofBirth Enrollcode Enrolleffdate Indefinite
Continue Terminate CaseClosed

I want to have the excel records that I am going to upload into the database look and if there is an existing record (looking at the SSN field) in the DB then I want it to update these fields (Indefinite Continue Terminate CaseClosed) to match what is already in the DB.

If there is not an existing record (looking at the SSN field) in the DB then I want those fields to be FALSE.

Is there any way for this to be an automatic process so I don't have to compare the Database and the Excel Document manually?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by NZBN In reply to Find & update new entry w ...

Yes there is, I'm pretty sure it works in 2002 but it definatly works in 2003:

In Excel select the data menu, goto import external data then select New database query.

Choose the access database option, then follow the wizard by your nose :)

Anytime you want to update the data select data then refresh data,

Have a good one :)

Collapse -

by bambamz In reply to

Poster rated this answer.
I am sorry I have been out of the office. This almost works but . . .I only want it to return records from the Database that match the SSN in the Excel Document. Right now it returns everything from the database. How do I do that?

Related Discussions

Related Forums