msjeb007
As to your initial question "Is there a way in VBA to delete the duplicate records?", the answer is yes.
You do need a unique index in the table to identify each specific record as already advised by others. When I am importing data with duplicates, I use a query to identify duplicates, then open a recordset of that query which has one occurence of each duplicate with grouping on all fields that determine that it is a duplicate, loop through that recordset and open another recordset containing the set of records that are the set of each duplicate, and loop through that, deleting all but the first occurrence.
When all duplicates are removed, add a unique composite index based on all of the relevant fields so duplicates cannot subsequently cannot be added to the table in the future.