Advice: Importing data into Access Table

[Terri Pecora]

Assuming you can link to the external system and link to
your SQL Server tables through access. If there is a
common key between the two, then you can write an insert
query to append the records that don't exist in the SQL
Server table.

Thanks
Terri