If you want to use Microsoft® Access® or Excel® to analyze data in a groov Data Store, these code samples are for you.
But these samples are more than “learning activities”—they include a fully-functional Access database file and Excel workbook that you can use practically out-of-the-box.
Just enter your groov Box’s Hostname and API key in the sample file, and immediately you can start accessing the data in your groov Data Stores.
Then, look under the covers at the VBA code in each sample to kickstart writing your own custom applications with Access and Excel.
You can download the code samples and instructions from the Opto 22 Downloads webpage:
- Sharing groov data with Access: https://www.opto22.com/support/resources-tools/downloads/groov_with_access-zip
- Sharing groov data with Excel: https://www.opto22.com/support/resources-tools/downloads/groov_with_excel-zip