ms query

  1. Default300

    ?Use Dynamic Named Range as Table / DataSource in MS Query?

    QUESTION: Is it possible to use an Excel Dynamic Named Range as a Table / DataSource in MS Query? AIM: I would like to use a Dynamic Named Range to trim superfluous (blank) rows from the Table before MS Query queries it. I was able to achieve close to what I wanted with a Static Named Range...
  2. B

    External Data and User Entered Text

    I am importing data to excel from an external database though MS Query. The data is similar to the table below. This information is for a weekly report, and though the bulk of the information remains the same, there is some small change from week to week. <?xml:namespace prefix = o ns =...
  3. H

    Choosing columns in Microsoft Query from Excel

    I am using Microsoft Query within Excel (ver. 2003) to bring in certain data from several tables currently stored in Microsoft Access. Following is a quick walk through of the steps I am using. From the Data menu, I am selecting “Import External Data” and then “New Database Query…”. Then when...
  4. rgrovier

    Flag whether queries need to run or not

    I have 54 Excel workbooks that each have 9 MSQuery queries. Each of the 9 queries query an Access query. Each Excel workbook takes about 2 minutes to update all 9 queries but it is not necessary to update every query every time the Excel workbook is opened. I'm looking for a way to eliminate...
  5. L

    MS Query / Pivottable / NamedRanges question

    I have a workbook with 13 worksheets, each containing identically formatted (fields are identical as well), but with different amounts of records. I all 13 worksheets to feed one pivottable in the same workbook. I've read that MS query can combine all 13 namedranges (worksheets) and could...
  6. S

    MS Query and Time Part of Timestamp

    I am trying to query an external database where I only want to return the rows that fall between the hours of 11 AM and 3 PM. I can't for the life of me figure out how to set up the criteria in MS Query to bring back the rows that meet the 11 AM to 3 PM window. The column being queried is a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top