Discover our Clipsal Smart Home packages as seen on the Block

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    How to use Excel to read data from ClearSCADA using MSQuery

    DISCLAIMER

    The example below is intended to demonstrate one or more features or methods and is presented as a configuration example only. Schneider Electric assumes no liability for the use or application of this example or any portion thereof.


    This article will show a simple way to connect to ClearSCADA database throught MSQuery from Microsoft Excel.
    Please note that the creation of the ODBC DSN is not in the scope of this article and it is covered in detail in ClearSCADA manual. Our example will use a DSN called "ClearSCADA", created previously.
    We will start opening Microsoft Excel (in this case, Excel 2016) and selecting:



    We can select the previoulsy created DSN now, in this case "ClearSCADA":



    Select the table and columns you want to retrieve data from and click "Next". In this case, we selected "FullName" and "CurrentValueFormatted" columns from the table "CDBPoint":



    We can include filters in the query, if needed, then click on "Next":



    Now we can select the sort order and click "Next":



    In this case we want the data to be shown in Excel, so we leave "Return Data to Microsoft Excel" selected and click on "Finish":



    Now we can select where in the spreadsheet we want to show data and click "OK":



    Results:

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance