I have an Access table linked to an external excel file that is updated
frequently. Is there a way to have only the new entries on the external
table appended to the Access table? (Using MS Office2003)

Thanks

Hello "maxaral".
"maxaral" wrote:
> I have an Access table linked to an external excel file that is
> updated frequently. Is there a way to have only the new entries on the
> external table appended to the Access table? (Using MS Office2003)

What do you mean with "linked"?
If you created a linked Excel table in your Access database there was
nothing to append.
So I guess you did not and you frequently add records through an import.
To identify what you already have imported, there should exist a column
containing unique values that can be used to identify the records.
1. Proposal (quick and dirty):
Make this column the primary key of the Access table.
You will get an error message about a number of key violations on every
subsequent import, but new records will be imported.
2. Proposal (like it more)
Create a linked table that points to the Excel file. Create a query that
finds the records of the linked table that have no mathing record in the
Access table (there is a wizard for that) and append these records to
the Access table.

--
Regards,
Wolfgang