When will a query run?

[philehof]

I'm running a query within MS-Access and pass it on to excel.
I would like the query to run without having to open MS-Access.
Therefore i am trying to figure out when MS-Access runs the query or
how do I control it when it runs.
Do I make my self clear?

Regards,
Philehof

[Justin Hoffman]

<ph******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

I'm running a query within MS-Access and pass it on to excel.
I would like the query to run without having to open MS-Access.
Therefore i am trying to figure out when MS-Access runs the query or
how do I control it when it runs.
Do I make my self clear?

Regards,
Philehof

You do not need to open Access at all. You can either write vba code within
your Excel workbook to get the data automatically, or if you don't want to
use code, use MS Query. From Excel select Data>Import External Data>New
Database Query - then it should be easy to follow the steps. You can then
select when you want it to update, eg when the workbook is opened, or
perhaps every 2 minutes.

[Philehof]

thanks for your answer.

I allready retreive data in excel via Oledb (i think it's oleDB). I
just wondered how to adjust the speed that is used to update the data
in excel.

I figured the following:

I used tools -> options -> advanced -> update interval (translated from
danish, might not be correct translated).
I set it to 30 sec. can someone confirm that that is the right place to
set the interval for updates?

Regards,
Philehof

[Justin Hoffman]

"Philehof" <ph******@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

thanks for your answer.

I allready retreive data in excel via Oledb (i think it's oleDB). I
just wondered how to adjust the speed that is used to update the data
in excel.

I figured the following:

I used tools -> options -> advanced -> update interval (translated from
danish, might not be correct translated).
I set it to 30 sec. can someone confirm that that is the right place to
set the interval for updates?

Regards,
Philehof

No - it isn't. Tools>Options>Advanced is in MS Access. You do not need to
open Access - you do not need to have this program on your computer - and
you cannot speed anything up by changing any settings here. It is not
Access which pushes the data out - it is Excel that pulls it in.
In Excel, Right-click any toolbar and choose to show the "External Data"
toolbar. Then select the data range and from the toolbar select the Data
Range Properties. It is here that you can set the refresh interval.
If you want to see it work, set the refresh interval to 1 minute and open
the database, as you change the data in the .mdb file you will see it get
automatically refreshed on you Excel spreadsheet.

[Philehof]

Thanks, your answer is very useful for me. Especially the part about
pull and push.

Regards,
Philehof