Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel ODBC driver created table/inserted data lost on application
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel ODBC driver created table/inserted data lost on application
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel ODBC driver created table/data not persistent | Excel Discussion (Misc queries) | |||
[Microsoft][ODBC SQL Server Driver]String data, right truncation | Excel Programming | |||
Excel ODBC Driver May Determine Wrong Data Type (Q141284) | Excel Programming | |||
ODBC Driver/Import Data | Excel Discussion (Misc queries) | |||
Data type problem - ODBC Excel '97-2000 Driver | Excel Programming |