GET RID OF DUPLICATE FIELDS EASILY

[HerickP]

hi,<br><br>Me again. I have an excel spreadsheet that I will import into access table, but this spreadsheet has many duplicate fields ( the reason is, There are fields for PO number, and on each Po there are many items, so when this was extracted out of another system, it created a line for each item, and different items belonged to the same PO, so the POs ended up in multiple lines)....How to remove the duplicates ( i really careless for the item part, I just need individual POs) and have a clean table ( or spreadsheet) with single but not duplicate POS?????

 

[gol4]

Go ahead and import the Excel table with the duplicates then eliminate the duplicates once you get in Access with a make table query