Good afternoon from sunny Calif
Using VBA I am reading data in from multiple XML files, and adding data to an indexed table.
If I try to add a duplicate record I get a error like:
"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship <snip>" and the data reading procedure stops.
How do I skip adding those records and just continue on reading the next XML record or file.
Thanks
JDB
Using VBA I am reading data in from multiple XML files, and adding data to an indexed table.
If I try to add a duplicate record I get a error like:
"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship <snip>" and the data reading procedure stops.
How do I skip adding those records and just continue on reading the next XML record or file.
Thanks
JDB