📌Note: If you have a new request, such as a SQL query or a new report set up, our Professional Services team are the best team to raise this with, as they will be able to advise you further based on your needs and current set up, click What to do if I have a new request for more information.
How to view information in Delta via a query in Excel, follow these steps below:
Open up a blank spreadsheet.
Click on the Data tab.
Click on the From Other Sources option.
Click on the From Microsoft Query option in the drop down.
Double-click DeltaWMS Data Source.
Click Cancel.
Click Yes to continue editing the query in Microsoft Query.
Click Close on the Add Tables box.
Click on View, SQL.
Paste the SQL script into the SQL Statement window and click OK.
If it says it cannot be represented graphically, click OK.
Close Microsoft Query.
Save the spreadsheet.
To refresh the data, press F5 or go to the Data tab and press Refresh to get the live information.
If you are unable to view the information:
Please raise a new case online and reference the title of this article.