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.