Updating Database with External Data

  • Thread starter Thread starter tnbubbachandan
  • Start date Start date
T

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?
 
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)
 
Back
Top