+ Reply to Thread
Results 1 to 4 of 4

Delete Using Microsoft Query

  1. #1
    Forum Contributor
    Join Date
    01-07-2004
    Posts
    314

    Delete Using Microsoft Query

    Hi all,

    Using Excel 2013.
    Is it possible to delete some records from Sheet1 if the records exist on Sheet2?

    I tried several SQL variations in MSQuery but all come back with error messages.

    I tried:
    Please Login or Register  to view this content.
    and

    Please Login or Register  to view this content.
    I keep getting these messages
    SQL Query can't be represented graphically. Continue anyway?
    and
    Syntax error in FROM clause
    thx
    w
    Kind regards,
    w

    http://dataprose.org

  2. #2
    Forum Contributor
    Join Date
    01-07-2004
    Posts
    314

    Re: Delete Using Microsoft Query

    Bump.

    thx
    w

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Delete Using Microsoft Query

    Don't know about 2013 but you can do it using VBA easily


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Contributor
    Join Date
    01-07-2004
    Posts
    314

    Re: Delete Using Microsoft Query

    Thx

    Agreed. Even easier in Access or Management Studio (SSMS)
    But I would like to figure out how to do it (if possible) using Microsoft Query.

    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Microsoft Query
    By chris789 in forum Excel General
    Replies: 1
    Last Post: 09-22-2011, 08:47 AM
  2. Microsoft Query
    By pdmkh in forum Excel General
    Replies: 20
    Last Post: 10-24-2009, 08:21 AM
  3. Importing Access query into Excel:Microsoft Query
    By ge0rge in forum Excel General
    Replies: 3
    Last Post: 04-02-2009, 10:51 AM
  4. [SOLVED] Microsoft Query rejects "nz" function in Access Query
    By Vaughan in forum Excel General
    Replies: 0
    Last Post: 05-04-2005, 01:06 PM
  5. Microsoft Query
    By R Ormerod in forum Excel General
    Replies: 0
    Last Post: 01-26-2005, 04:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1