PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Writing to data file from PxPlus ODBC in Excel  (Read 220 times)

Mike Hatfield

  • Gold Member
  • ****
  • Posts: 55
    • View Profile
Writing to data file from PxPlus ODBC in Excel
« on: May 08, 2020, 02:59:41 AM »
Hi All,

I remember a few years ago that I worked out how to use the ProvideX ODBC to update a Providex file from Excel.
1. Populate Excel using the Providex ODBC from dictionary defined file.
2. Modify a cell and then write that row back to the ProvideX file.
3. Delete a row and that 'record' would be deleted from the ProvideX file

I just can't remember what the ProvideX ODBC configuration was to achieve this.

Has anyone done this and care to share?

Thanks
Mike H