Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
Link copied. Please paste this link to share this article on your social media post.
Description
In order to connect Geo SCADA to an Excel Spreadsheet, please use the following steps as your guide:
- Create Spreadsheet with column headers and populate rows with appropriate text
- Create ODBC SYSTEM DSN Connection to the Excel File
- Create Geo SCADA objects in order to grab data
Instructions
Create Spreadsheet
In order to work with a data set, we need to create a spreadsheet which will act as our data source.
- Create a spreasheet with the appropriate column headers. This example uses Commodity and Value as the column headers.
- Populate the spreadsheet with the data you require.
ODBC Connection
We need to make this spreadsheet accessible to Geo SCADA via ODBC. To accomplish this, we need to configure and ODBC SYSTEM DSN connection.
- Open the Control Panel | Administrative Tools | Data Sources (ODBC ) application
- Select SYSTEM DSN | Add
- Select "Microsft Excel Driver" , select the newest version that supports the *.xlsx file. Other wise the standard *.xls connection is fine.
- Name the Data Source Name to something meaningful, and Browse to the Workbook Name.
- Press OK when complete.
Create Geo SCADA Objects
Now that we have a Data Source and Connection, we need to bring that data into Geo SCADA. A number of objects must be created and linked for this to happen.
- Create the following objects in Geo SCADA: ODBC Connection, ODBC Query, ODBC Analog Point.
- Configure the Connection and browse to the DSN you created.
- Configure the Query object by selecting the Connection you created and enter a Query:
- Configure the Analog Point by selecting the Query and Row and Column for the result:
Analog Point.PNGAnalog Point.PNG Notes
Once all items are In Service, the Excel spread sheet is no longer editable. The open connection to the file from the DSN locks the file from being opened by other applications. To update values in the Spreadsheet, you should connect via another ODBC connection and use the UPDATE or INSERT commands.
To ensure the data always results in the selected Column and Row, you can edit the query on the Point Tab to filter based upon a unique row so that there is only one result returned from the query such as:
SELECT * FROM [Sheet1$] WHERE Commodity = 'Oil'
Author
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.