Outputto and Excel (MS Access)

Outputto and Excel
message from Ricardo Coelho on 1 Jun 2004
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?

=?Utf-8?B?SmFja2llIEwu?= replied to Ricardo Coelho on 1 Jun 2004

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 replied to =?Utf-8?B?SmFja2llIEwu?= on 2 Jun 2004

Jackie,

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

Thank so much;

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

Archived message: Outputto and Excel (Microsoft Access Database)