Updating Database with External Data

[tnbubbachandan]

I am in need of so much help and I am sure it is simple. How would you
dictate to Access to update current table with new information from
external data. I pull an external file every day and import into
Access. This file has one field that may change in an entry that is
already in the table. How do I get Access to automatically accept the
new entry and delete the old?

 

[Nikos Yannacopoulos]

Make your external file a linked table (assuming the name
is the same every day).
Make an update query linking your main table to the
external file for updating existing records, or
Make an append query (on the external file, appending to
the main table) to add new records.

Nikos Y. (nyannaco at in dot gr)