updating the existing table importing data for the same table

[diggermf]

Hi All,

I have imported a table 'A' using ODBC connection, When I tried to import the data for the same table 'A' next day to append the new records processed or update the existing records its creating with a table A1 instead of updating the existing table "A"

Could someone please clarify how i can append or update the existing data which was downloaded already with the new data processed the next day.

Thank you

 

[Pampers]

I think you could either use a linked table (right click) in the tables an then choose Linked Tables. Or, if you want to have the data/table locally, use an append query to append new records to your table A.

Pampers
Keeping it simple can be complicated