How to make the application wait until ODBC Extract is finished

  • Thread starter Arvid Raaen Gjertsen
  • 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
 
T

Tony Sardina

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.
 
A

AB

and makes sure that in querytable properties you uncheck the 'enable
background refresh' option.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make my vba wait? 3
Wait until MSQuery Refresh finished 1
How to make Excel the active application 4
Macro to wait until an excel spreadsheet macro has finished runnin 0
ODBC takes time to update 2
How to extract data from autofiltered worksheet 0
How to make sure one query has finished before the next runs 0
Excel2000 VBA: How force the procedure to wait until queries are refreshed? 2

Top