I have a db table (MS Access 2002) which has a list of vendor names. I would like to import that data into another table whith a vendor field.
now the problem is that there are soem duplicate vendors. in the new table's vendor field duplicates are not allowed. so i need to run a query which will go through the original table and delete any duplicate records... nto sure how to do that. any suggestions?? please??