Deleting Multiple Records in Microsft Query for Excel Import

Posted on 2012-08-17
    Last Modified: 2013-12-02
    Hi All,

    I'm running a query that will return data containing samples from vet practices and i have information on vet practice, client, animal, owner , sample code, test codes etc. i have run the query but it's supposed to have 63 records but it's giving me 8192 records, i have done a criteria  to select only the test codes i want, how can i delete the multiple records? thanks
    Question by:Yemi7
      LVL 24

      Expert Comment

      Is your query doing a select distinct ? There might be historical records that are being pulled in

      Accepted Solution

      Hi All,

      Managed to fix it, it was the links that was producing the multiples thanks

      Author Closing Comment

      it was the links that was causing the multiple records

      Write Comment

      Please enter a first name

      Please enter a last name

      We will never share this with anyone.

      Digital marketing agencies have encountered both the opportunities and difficulties that emerge from working with a wide-ranging organizations.
      Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
      Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
      This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

      737 members asked questions and received personalized solutions in the past 7 days.

      Join the community of 500,000 technology professionals and ask your questions.

      Join & Ask a Question

      Need Help in Real-Time?

      Connect with top rated Experts

      18 Experts available now in Live!

      Get 1:1 Help Now