I am parsing out a text file. I have loaded the fields into a an Array of Arrays. RecordArray( )( )
On a rare occasion my text file contains a duplicate record.
I am using a for next loop
For Y = 0 to RecordArray.GetUpperBound(0)
Insert Into Blah Blah Blah
When I go to insert the record in the table I get error #2627 which I catch in a try catch block. How can I use the Catch Block that if it is an error #2627 that we increment Y and continue processing the next record.
Thanks In advance