OptoNews Tip: Share SNAP PAC data with Excel or Access

Posted by Jean Femia on Nov 10, 2016 12:28:28 PM

Share data from an Opto 22 SNAP PAC controller with Access databases and Excel spreadsheetsHave you wanted to share I/O point or variable data from your SNAP PAC controller with a Microsoft® Excel® spreadsheet or Access® database? 

  • Maybe you're tracking sales in a spreadsheet and want to adjust production to match projections.
  • Maybe your PAC is monitoring equipment on-time and energy usage, and you want to add that data to an equipment maintenance database.

You might have a lot of good reasons to share data between your control system and a company database or spreadsheet, but you need to do it securely.

The new RESTful API in SNAP PACs gives you that capability—and these two new sample files with step-by-step instructions make it really easy. 

SNAP PAC RESTful API to Excel Spreadsheet Example—Read from and write to an Opto 22 SNAP PAC programmable automation controller using Visual Basic for Applications (VBA) with Excel. The sample Excel file is an interactive spreadsheet that can query your PAC and then build URL paths for the data in your control strategy. You don’t even need to know the I/O point and variable names on your PAC. The included technical note explains the sample. 

SNAP PAC RESTful API to Access Database Example—This interactive Access database sample builds commands to read data from a SNAP PAC and store that data in an Access table. Be sure to see the included technical note.

How do the samples work?

The RESTful API is a way for software applications to securely access data in the PAC controller by making GET and POST requests. You can see the complete Opto 22 RESTful API on developer.opto22.com.

The samples use the API plus common features within Excel and Access to move data to and from the PAC. In both samples, you can use the files as is to move data. Or you can see and edit the code behind the sample to understand it more fully.

Get the Excel sample Get the Access sample

Topics: Internet of Things, Tips, IoT, optonews, PACs, API, REST API, REST, IIoT, Industrial Internet of Things, OptoNews 2016-11-09

Written by Jean Femia

Jean Femia writes about technical subjects and has focused on automation and control systems for more than 15 years. She likes learning about technology and taking corners in her Honda S2000.
Find me on:

    Subscribe to Email Updates

    Recent Posts

    Posts by Topic

    see all