PxPlus User Forum

Main Board => Discussions => ODBC => Topic started by: Mike Hatfield on May 08, 2020, 02:59:41 AM

Title: Writing to data file from PxPlus ODBC in Excel
Post by: Mike Hatfield 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