ms query

  1. 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...
  2. 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...
  3. 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...
  4. 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...

Some videos you may like

This Week's Hot Topics