Importing tbl via ODBC

[goslincm]

Hi, I am importing a table into Access via a ODBC and this import could be daily or weekly. The purpose of the import is to make sure that one of the tables in Access is updated anytime there is a change to a couple of particular fields in the imported table.

I don't know how to set this up to make it work. Can there be a relationship established, can referential integrity be enforced? I'm stuck.

 

[IGPCS]

why dont you link the table via ODBC connection so its updated live?

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[goslincm]

Understand I'm coming into this project in mid-stream. Users have been using this Access Database for 4 years. The individual who created he Access database added addition fields to his version of this table. So while he is importing and looking to catch any changes to the incoming table, he is also inputting additional info in his Access table.