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...

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 =...

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...

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...

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...

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...