PDA

View Full Version : How to Export Query Results To Excel



richardSmith
07-15-2013, 05:13 AM
I have a user form where the user will pick start date then end date. These dates are then passed to the query so the query will only show data within the selected date ranges.

How can I then, take those query results and export them (no headers) to Excel?

*Or if someone here has a better way of achieving this, I am open for suggestions :)

EDIT --
I want to export them to an already existing Excel file.

stanl
07-20-2013, 08:33 AM
I want to export them to an already existing Excel file.

I would suggest placing the query into ADO then using CopyfromRecordset after removing the existing range (minus headers) in the Excel file.