Exporting a Query

  • Thread starter Lost and Looking for Help
  • Start date
L

Lost and Looking for Help

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
 
K

Klatuu

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.
 
Top