Outputto and Excel

[Ricardo Coelho]

Hi,

I'm building a small code to export 3 queries to an excel
file. I need it in 3 separate spreadsheets (and in a
single Excel file). However, every time that I execute
the OutputTo it creates a new Excel file with a single
spreadsheet. Any tips on that?

 

[Guest]

Have you thought about linking from the Excel file to the database? You can run Make Table queries in your database and then set up the spreadsheet in Excel. Choose Data - Get external Data - database and you can browse to your tables. The data can then be refreshed. If you do not need to use queries, then you can update from Excel at any time. If you have to use make table queries to create your tables, then you will have to run those in Access before updating in Excel

Hope this helps


----- Ricardo Coelho wrote: ----

Hi,

I'm building a small code to export 3 queries to an excel
file. I need it in 3 separate spreadsheets (and in a
single Excel file). However, every time that I execute
the OutputTo it creates a new Excel file with a single
spreadsheet. Any tips on that?

 

[Ricardo Coelho]

Jackie,

I think that it´s a good idea. I tried it but I could not
see my CrossTab Query in Excel (External Data). I saw
other regular queries through excel, but not the one that
I was looking for. Can Excel get CrossTab Query? Any tip
on how to save this query (CrossTab) in a table?

Thank so much;

Ricardo

-----Original Message-----
Have you thought about linking from the Excel file to

the database? You can run Make Table queries in your
database and then set up the spreadsheet in Excel.
Choose Data - Get external Data - database and you can
browse to your tables. The data can then be refreshed.
If you do not need to use queries, then you can update
from Excel at any time. If you have to use make table
queries to create your tables, then you will have to run
those in Access before updating in Excel.

Hope this helps.



----- Ricardo Coelho wrote: -----

Hi,

I'm building a small code to export 3 queries to an excel
file. I need it in 3 separate spreadsheets (and in

a