|
How to make the application wait until ODBC Extract is finished
I have a application with several Microsoft Query ODBC extracts to Excel.
How to make the application wait until the extract is finished. The application will start processing on the extracted data but must not go on before the data is fully extracted. I have also the same problem with running SQL-sommands from Microsoft query inserting data into commands filling a DB2 table. Whenti konow when the query is finished -- Arvid R. G. |
How to make the application wait until ODBC Extract is finished
In your refresh the data section of your code try putting in the following command .Refresh BackgroundQuery:=False
This worked in the code I was using where I had dependent code following it. On Wednesday, August 19, 2009 3:48 AM arvid.raaendonotspam.gjertse wrote: I have a application with several Microsoft Query ODBC extracts to Excel. How to make the application wait until the extract is finished. The application will start processing on the extracted data but must not go on before the data is fully extracted. I have also the same problem with running SQL-sommands from Microsoft query inserting data into commands filling a DB2 table. Whenti konow when the query is finished -- Arvid R. G. Submitted via EggHeadCafe ASP.NET JSON Cookies and Excel http://www.eggheadcafe.com/tutorials...and-excel.aspx |
How to make the application wait until ODBC Extract is finished
and makes sure that in querytable properties you uncheck the 'enable
background refresh' option. On Mar 1, 7:59*pm, Tony Sardina wrote: In your refresh the data section of your code try putting in the following command .Refresh BackgroundQuery:=False This worked in the code I was using where I had dependent code following it. On Wednesday, August 19, 2009 3:48 AM arvid.raaendonotspam.gjertse wrote: I have a application with several Microsoft Query ODBC extracts to Excel. How to make the application wait until the extract is finished. The application will start processing on the extracted data but must not go on before the data is fully extracted. I have also the same problem with running SQL-sommands from Microsoft query inserting data into commands filling a DB2 table. Whenti konow when the query is finished -- Arvid R. G. Submitted via EggHeadCafe ASP.NET JSON Cookies and Excel http://www.eggheadcafe.com/tutorials...350-8611-b...- Hide quoted text - - Show quoted text - |
| All times are GMT +1. The time now is 04:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com