Export Qry results to Excel/CSV

Results 1 to 2 of 2

Thread: Export Qry results to Excel/CSV

  1. #1
    Ian Cornish Guest

    Default Export Qry results to Excel/CSV

    Is it possible (and if so, can you tell me how) to run an SQL qry against a DB, and then get the results redirected into a file that is opened with Excel, rather than have results displayed on the screen ?<BR><BR>Thanks in advance

  2. #2
    Join Date
    Dec 1969

    Default RE: Export Qry results to Excel/CSV

    If you are using SQL 7, you should be able to create a "package" under the DTS, and have it export to a excel spreadsheet. If you are trying to do this in the browser, www.codeave.com, has a quick example of how this can be done. Or, you could do as we have, and write a COM object that takes the query, and creates a CSV file from it.<BR><BR><BR>HTH<BR><BR>Jerry

Posting Permissions

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