Consulting

Results 1 to 2 of 2

Thread: How to Export Query Results To Excel

  1. #1

    How to Export Query Results To Excel

    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.
    Last edited by richardSmith; 07-15-2013 at 06:07 AM.

  2. #2
    VBAX Master stanl's Avatar
    Joined
    Jan 2005
    Posts
    1,141
    Location
    Quote Originally Posted by richardSmith
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •