How to Not Minmize Access Window When I Go to Excel

J

JB

Hello,
I run the same query on a database but with different dates for each
run. After each run I key-in the results to an excel spreadsheet.
This works fine. What happens though is the Access window minimizes
each time I go to the excel spread sheet. I then have to expand the
access window, run the query, key-in the data to excel and repeat. Is
there a way to keep the Access window open and not minimize each time
I go to the spreadsheet?

Thanks.

JBEsr
 
J

jeff

Hi, JB,

Why not use the built-in Excel functionality to
automatically load your data? Try Menu: Data-> Import
External Data->New Database Query; and put your
query there? You can return whatever columns you need
directly into Excel.

It's also possible to set your varying date into a cell
and use VBA to pass the date into the database. (Code is
available if you want to try it)

jeff
 
J

JB

Thanks Jeff I will try that.
Would you send me the vba code you referred to. I do use macros, but
I am limited pretty much to the macro recorder and what others have
graciously provided.

JBE Sr.
 
Top