Download Query outputs to .xls or?

[Guest]

I will be designing approx 60 queries and the requirements are to be able to
download the query outputs to...
..xls
..pdf
..txt
..rtf

What would be the easiest to do? Is their a certain way the queries need to
be designed or?

Thanks again


Thanks again

 

[Guest]

For .xls use TransferSpreadsheet
For all others, use TransferText
you can look up the details in VBA Help.
I thnk you may have to have a specific driver to create a pdf file, but I
don't know the details on that.