+ Reply to Thread
Results 1 to 4 of 4

How can I find MSQuery in windows 12

  1. #1
    Forum Contributor
    Join Date
    02-01-2021
    Location
    Manchester
    MS-Off Ver
    365
    Posts
    222

    How can I find MSQuery in windows 12

    For the last 25 years I have happily used MSQuery to extract data from an accounts database. I am now using a computer with windows 12 and I cant find MSQuery anywhere. I Get Data>from other sources>ODBC and I cant see how to use this. I am looking at a Nominal Ledger which has account numbers and I would like to only look at accounts with a reference number greater than 4000 but there is no way I can see to do this.
    In short can I still find MSQuery and if yes where do I find it?
    If MSQuery has gone where can I find how to use the ODBC setup now available in "Get Data"?
    John

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,975

    Re: How can I find MSQuery in windows 12

    Windows 12 hasn’t been released. MSQuery used ODBC connectors so as long as you have one set up for your accounts do, you should be able to use that. Is there no connector for Power Query to your db?
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: How can I find MSQuery in windows 12

    MS-Queries seems to have disappeared from Excel 365.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: How can I find MSQuery in windows 12

    I found the answer here: https://answers.microsoft.com/en-us/...c-e9c0a6f4b0f2

    Go to File > Options > Data. There is a section to enable legacy queries. MS-Query is one of them.

    I have software that updates the MS-Query command text "on the fly" You can do a lot of calculations on the spreadsheet, modify the command string and then run it. - It may be harder to use VBA to update power query this way.

+ 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. How to find top 100 results using MSQuery
    By Osprey2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2021, 11:06 AM
  2. [SOLVED] Windows cannot find C:\ error message
    By Shruder in forum Microsoft Windows Help
    Replies: 2
    Last Post: 10-05-2020, 03:00 AM
  3. [SOLVED] Using WMI to find Windows Login Time
    By DreamEyes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2018, 08:48 AM
  4. Replies: 3
    Last Post: 08-18-2015, 09:04 AM
  5. [SOLVED] Windows 7 :Windows 7 repair installation without booting into windows?
    By shanew in forum Microsoft Windows Help
    Replies: 0
    Last Post: 11-28-2009, 01:28 AM
  6. Find Windows Handle
    By drawlings in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2006, 05:03 AM
  7. How to find Windows login name with code?
    By SupperDuck in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2006, 04:00 AM

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