Exporting Multipe query to a single workbook

[Guest]

is it possible to export mutiple queries to a single workbook with a tab for
each export using access macro outputto

 

[Douglas J. Steele]

See whether my July, 2005 "Access Answers" column in Pinnacle Publication's
"Smart Access" is enough to get you going.

You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html

 

[Pat Hartman \(MVP\)]

Although Doug's article is very useful, it might be overkill for your
situation. Try using the TransferSpreadsheet Method first. Help explains
what the arguments do. You may need to create a query to select the data
you want to export especially if you want to do any formatting.