Hi members,
I would like to ask you if you know what is the best method to import a Table from Excel o Access to PI System Explorer Library and have it updated all the time, without the need of "import" every time when we modify one or more cells.
I have been informing myself about the "Table Link" option, instead of using "Table Import" option, but I am not sure of if this option is the appropriate one, according to my goal.
Please, I would be grateful to hear from your helpful comments based on your experience.
Thank you very much in advance,
Regards,
Omar.
In fact, I have tried to follow the steps of https://livelibrary.osisoft.com to link a excel file table to PI system explorer Library, but unfortunately, a window with a error message has popped-up :
"Unable to link to external table: Unexpected Server Error: 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'.
Use Event Viewer to see the PI AF Server log file for more information."
What could be the reason?
Thanks for your support,
Omar.