none
Copy selective data from one table to another table in access RRS feed

  • Question

  • MY DATABASE IS IN MS ACCESS WHICH IS USED FOR MY ASP.NET WEB. NOW I WANT TO COPY SOME DATA FROM QUAL TABLE (WING.MDB) TABLE TO SHREYA TABLE IN POOJA.MDB (WITH A QUERY FOR ONE TIME WHICH I WILL RUN QURY MANUALLY ONLY. NO NEED OF WEB CODING)

    WHERE QUALIFICATION IS (OY and MED or LED or GED) or OTY

    I TRIED THIS QUERY

    SELECT pno, qualification, recommendations INTO shreya IN 'pooja.mdb'
    FROM milqual
    WHERE (qualification = 'MED' and qualification = 'OY') or (qualification = 'OTY'

    MY REQUIREMENT IS THE PERSONS

    WHO HAD DONE OY AND DONE MED OR LED TO BE COPIED

    OR WHO HAD DONE OTY IS TO BE COPIED

    BUT AS PER MY QUERY THE PERSONS NOT DONE OY AND DONE MED OR LED IS ALSO COPIED.


    I am a System Administrator at Vadodara

    Friday, February 22, 2013 1:58 AM

Answers

  • Hello,

    This forum is dedicated to developers who are publishing apps for Office or SharePoint directly to the Office Store for Office 2013.

    You may want to direct your question to another MSDN forum such as the Access for Developers Forum here:

    http://social.msdn.microsoft.com/Forums/en-US/accessdev/threads

    Hope that helps.

    Best regards,

    Jes

    • Proposed as answer by JesBModerator Friday, February 22, 2013 5:38 PM
    • Marked as answer by ErikOlson Friday, February 22, 2013 6:51 PM
    Friday, February 22, 2013 5:38 PM
    Moderator