What I would do in this case is run a couple of queries. First I would create a delete query where the key field in the original table are the same as the new table (equals join). Otherwise, it will not append the new information for those records. Then, I would run the append query to get all new (and updated) records
You would need to be cautious however, if you have referential integrity set up with the original table. You do not want to delete those records if it will cause a record to be deleted in a linked table
Hope this helps
----- lisa wrote: ----
The import fields are exactly the same. By importing the
speadsheet file, the data will be either new records or
new information for existing records (like new address,
telephone, etc). Will Access create a new record for the
existing records and cause me to run a query to append
the record to keep the database clean from dupes? The key
is the same in both files
-----Original Message----
There are a couple of ways you can accomplish this. In
a one time import, you can bring the new spreadsheet into
a table in Access and if the fields are not exactly the
same as the original table, you can make an Append Query
where you can assign the new fields to the existing
table. If the fields are the same, you can copy from the
new table and Paste/Append into the old one. Do you
have key fields that may cause a problem? If you have
established key fields, you may loose records on the
append. It all depends on your data
