How to make the application wait until ODBC Extract is finished

  • Thread starter Thread starter Arvid Raaen Gjertsen
  • Start date Start date
A

Arvid Raaen Gjertsen

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
 
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.
 
and makes sure that in querytable properties you uncheck the 'enable
background refresh' option.
 
Back
Top