Excel Querying Data Warehouse (Microsoft Query)

Excel Querying Data Warehouse (Microsoft Query)

It appears recent Office 365 Updates (2024) have impacted the menu choices for those of you who use the Microsoft Query to access State Data Warehouse. 

 
If you no longer see the Microsoft Query in the 'Other' query option, please see below for instructions.  You will need to enable "from Microsoft Query (Legacy)". 

Instructions
In an Excel spreadsheet, go to FILE and then to Options

Then select Data

Locate the section Show legacy data import wizards,  and ensure that the From Microsoft Query is selected. 

When you open a new excel worksheet to create a new query for Statedw, 

In the Data menu, select Get Data,  in the drop down menu choose  Legacy Wizards, and there you will see from Microsoft Query Legacy


    • Related Articles

    • QRG - Using Excel to query data warehouse

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1CzcUic3qykVURnFS1yrkN-roU5YvQzJv/view ) Introduction To access State Data Warehouse using excel or other tools, create a DTS helpdesk ticket, they need to install ...

    • QRG - Using Access to query data warehouse

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1jcxI35q1Rpz_gLCbOonQaWSgO51duFq7/view ) Introduction Open Database Connectivity (ODBC) database. Similar to the state data warehouse, you’ll need to install an ...

    • Labor Plus Query

      Labor Plus is a link within the Online Accounting Journal query. If you have accesss to the online accounting journal, then you have access to see Labor Plus. For privacy reasons, State Data Warehouse hides many vendor names. If you were to add the ...

    • Data Warehouse - Data Dictionary

      Information Data Warehouse has published a Data Dictionary, sharing all of the State Datawarehouse Tables and Fields. Some tables have details and joins to use, where other less commonly used tables simply share the field names. This should be ...

    • ODBC Connection Error When Connecting to Data Warehouse via Microsoft Access or EXCEL

      Problem An error is received when trying to access. ODBC call failed  Specified driver could not be loaded due to system error 126: The specified module could not be found. (Adaptive Server Enterprise, C:\Sybase\DataAccess\ODBC\dll\sybdrvo.dll)(#160) ...