A
Andri
Please help, i have an existing table - ITEM.
then intend to APPEND the records by Importing from Excel.
Due to the ITEM# is Unique FIELD (in Table ITEM), i would like to do the
above subject when importing from EXCEL if duplicate, and BLANK if no
duplicate.
Success, to use UPDATE by Query Facilities / with SQL but must do one by one.
But this time, i have 870Items duplicate records.
How to do it automatically?
TIA.
then intend to APPEND the records by Importing from Excel.
Due to the ITEM# is Unique FIELD (in Table ITEM), i would like to do the
above subject when importing from EXCEL if duplicate, and BLANK if no
duplicate.
Success, to use UPDATE by Query Facilities / with SQL but must do one by one.
But this time, i have 870Items duplicate records.
How to do it automatically?
TIA.