Exporting a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a query and i would know like to export that query to excel.
Can I export this query to an existing workbook and to a specific worksheet
in that workbook? Thanks for the help
 
Not sure what you mean. If you are wanting to export the data the query
returns to an Excel spreadsheet, use the TransferSpread method.
If you are wanting to run the query from Excel, you can use MSQuery from
withing Excel to attach to your database and run the query from there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Key 3
Fixed Numbers 3
Export Format not avaiable 1
export to xls. 2
Multivalue field and exporting to Excel 1
Query Export 2
Exporting Query from Access 2007 to Excel 2007 4
query export wont allow a zero value? 2

Back
Top