Compare import data with current data

[Nick]

I have text table ALID0001 from A: that I currently import to Table ALI0001
in DB. The problem is when I have to update the DB table with the same date,
I must delete said date or I will get duplicate enteries. Is their a way
before importing data from A: to have it compair dates between the two tables
and delete data by date in DB before importing from A:
Macro
Transfer type: Import Delimited
Name: ALID0001 Import Specification
Table Name: ALID0001
File Name: A:ALID0001.txt
Has field names: Yes

 

[Andy Hull]

Hi Nick

You could create a linked table to the file and use a query to delete rows
from the destination table based on the date(s) in the linked table - then
import as normal.

Or, import into a "staging" table - compare this with the final destination
table deleting where necessary - then append into final destination table
from the staging table.

Regards

Andy Hull