Prev: Track and write the number of times that sub is run into a cel
Next: Sheet change event to return sheet name just left
From: Farid Z on 19 May 2010 10:34
Using native ODBC API I connect to an Excel spreadsheet using Microsoft Excel
Driver (*.xls) 4.00.6305.00 successfully and I am able to create a new table
and insert data into the new table and retrieve the inserted new data
successfully.

While my application is running I can disconnect and reconnect to the Excel
data source and see the new table and its data. However, when my application
exit the new table and inserted data are lost and the spreadsheet is never
updated.

Is there a special ODBC command to close/save an Excel worksheet?
From: Farid Z on 19 May 2010 12:01
OK. I found out the cause of this issue was a code path that skipped calling
::SQLDisconnect before freeing connection handle. Now it all works
 | 
Pages: 1
Prev: Track and write the number of times that sub is run into a cel
Next: Sheet change event to return sheet name just left