DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Save results of query

  1. #1
    Paul Guest

    Save results of query


    Hi,
    Is there a way to save the results of a query to a file or format so that
    I can then stick it in a spreadsheet. The data in the extracted cols do contain
    spaces and certain control characters so a ctrl-c ctrl-v into Excel fills
    col A which ...
    Thanks in advance.
    Paul

  2. #2
    DaveSatz Guest

    Re: Save results of query

    see
    http://www.mssqlserver.com/faq/general-flatfile.asp

    "Paul" <pjvaz@hotmail.com> wrote in message news:3a240403$1@news.devx.com...
    >
    > Hi,
    > Is there a way to save the results of a query to a file or format so that
    > I can then stick it in a spreadsheet. The data in the extracted cols do

    contain
    > spaces and certain control characters so a ctrl-c ctrl-v into Excel fills
    > col A which ...
    > Thanks in advance.
    > Paul




  3. #3
    bz Guest

    Re: Save results of query

    If you are using SQL Server you can use the query in the DTS Export wizard.
    The DTS allows you to export directly to a Excel workbook along with many
    other formats.

    Colin




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center