I'm try to import data from a SQL table to
a access table using DTS. But i only want
it to import if the Contract_No in the SQL
table is not in Access table which is the primary
key in each table.
I have set the DTS up to do a straight import but
where can i tell it to check the Contract_No field.
Can someone point me in the right direction.
a access table using DTS. But i only want
it to import if the Contract_No in the SQL
table is not in Access table which is the primary
key in each table.
I have set the DTS up to do a straight import but
where can i tell it to check the Contract_No field.
Can someone point me in the right direction.
