Access Gurus help needed

[spaceman]

Heres what my co workers did to the database,

Filtered the old xdatabase (Access 97) by selection to get only the APG works.
Exported this filtered database to a text file. (comma format)
Imported the text file info to the new paintings database (Access 2000). An import error report came up and when we opened the new paintings database it had duplicated every one of the new APG entires along with the 7000+ prevoius entries, only in the duplicate entries all of the information was in the wrong columns. The problem might have been that the APG works had letters (APG) and numbers in the Doyle # column, which in the new x database was set as a numbers only column in design view.


Now there is a duplicate entry for every valid entry,and i cannot seem to come up with a way to undo these changes :/
any suggestions.Access is something I never use on my own...and what info i learned from taking the course has all but vanished!:Q

 

[EagleKeeper]

Access has a wizard to help remove duplicate records. It may help.

Otherwise an options would be to create a new table with one additional field that is autonumbered.
Paste in the corruped table (after sorted by the duplicate entry field) to the table define above.
The write a quick filter to display in a query all the odd or even entries. Delete the reqult of the query.

This is brute force but not as bad as doing them all one at a time.