I am wondering if it is possible to use Access to import the data similar to how it is imported into Excel?
When talking about Microsoft Excel, are you referring to PI DataLink? If so, PI DataLink is an add-in to Microsoft Excel. It doesn't work with Microsoft Access.
Programmatic access however is possible e.g. through Access ODBC import and PI ODBC Driver.
Another option is to import Excel data from within Access after getting the data through PI DataLink.
It might however be better using one of our PI SQL Family products if you like to use SQL queries for reporting.
Can you talk a bit about what you like to accomplish?
Thanks for the reply Gregor,
I am trying to create quite a few KPI's and graphs for a distillation tower. My thought was if I could import the data into access it would be easier to work with the excel data. I probably am trying to over complicate the system. I think it will be best to plow forward with what I am working on now.
Thank you for explaining a bit more what caused you to ask that question. We all have our personal preferences also based on what we are used to. There's a bunch of tools available with PI and sometimes there are even different choices. Please continue asking when in doubt.
Retrieving data ...