Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    6

    Unanswered: delete duplicates

    hey everyone,
    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??

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    why delete from the old table? why not just insert single vendors into the new table?

    insert into newtable
    (vendornubmer, vendorname)
    select vendno, vendname
    from oldtable
    group by vendno, vendname

    rudy
    http://rudy.ca/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •