• State Not Answered
  • Replies 2 replies
  • Subscribers 2 subscribers
  • Views 59 views
  • Users 0 members are here
Options
Related

Excel or csv driver in PI System explorer Data reference

DevenPatel

Hi. Is it possible to connect to a csv file in pi system explorer and extract the values in a table in PI Asset Framework similar to connecting to sql server and getting the values via "Microsoft OLE DB Provider for SQL server". I mean is there a driver in pi system explorer like "Microsoft Excel driver" or "Microsoft Access Text driver" to connect to excel or csv files. Please reply to me about this.

Parents
  • 0

    Could you help clarify some issues: do you want this to be a one-time import or do you wish it to be a dynamic link? A one-time import could populate a local AFTable. If you want it to be dynamic then the preferred connections would be:

    1) SQL Server

    2) Microsoft Access

    3) Excel

    I think your energies should be focused on how to import your CSV file into one of the above.

     

Reply
  • 0

    Could you help clarify some issues: do you want this to be a one-time import or do you wish it to be a dynamic link? A one-time import could populate a local AFTable. If you want it to be dynamic then the preferred connections would be:

    1) SQL Server

    2) Microsoft Access

    3) Excel

    I think your energies should be focused on how to import your CSV file into one of the above.

     

Children
No Data