General information
Title:
ODBC Excel Driver no SQL update
I am having too much fun with 32bit ODBC Excel 97 Driver and maybe someone can halp me to understand that I am doing wrong.
I have a spreadsheet in Excel 97 format with range name excMyRange and in VFP 5.0 I have a database container with connection based on ODBC Excel 97 and updateble View called MyView. I can query the data in view but if I try to change it I get ODBC error (or I think it is ODBC error) saying "This operation requires Updatable query". I think my query is updateble then why ODBC thinks it is not ?
Please share any expirience with ODBC VFP and Excel spreadsheets. I would like to be able to update data in spreadsheets using VFp and ODBC.
Thank you.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only