Re: Can I output query result to text files in QueryAnalyzer?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rohtash Kapoor (rohtash_nospam_at_sqlmantra.com)
Date: 03/20/04 

Date: Sat, 20 Mar 2004 10:02:15 -0800

You can send the output in file in different formats.

In Query Analyzer goto Tools-->Options and then click Results tab and under
the "Results Ouput Format" choose "Comma delimited (CSV)" and when you
save the output in a file save with .csv extension.

Open the file in Excel. 

---
Rohtash Kapoor
http://www.sqlmantra.com
"TomTom" <no_spam_please@tomtom.com> wrote in message
news:OZZB$NqDEHA.2404@TK2MSFTNGP11.phx.gbl...
> Yes, I was able to export into text. The result, however, is not easily
> formattable in Excel... Any good methods?
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote
in
> message news:OGWZqEqDEHA.2052@TK2MSFTNGP11.phx.gbl...
> > TomTom,
> >
> > Query Menu, Results to File.
> >
> > -- 
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> >
> >
> > "TomTom" <no_spam_please@tomtom.com> wrote in message
> > news:uy%230a$pDEHA.712@tk2msftngp13.phx.gbl...
> > > I am wondering if I can output the query result directly to text files
> in
> > > QueryAnalyzer. Is this supported?
> > >
> > > I use SQL Server 2000. Thanks!
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Which query is running
    ... GetAddress is the name of a function which combines and formats the address ... Each query could contain more than 1 output field that need parameters to be ... This is part of a Club database. ... On Error GoTo GetParameters_Err ...
    (comp.databases.ms-access)
  • Re: Eliminating nulls in a table
    ... this is creating problems when I export to ascii, Excel or other ... formats. ... query that selects all the fields from the table, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Parameter Query and Date calculations....
    ... the CVDATE() didn't make any difference to the records that were returned. ... append query so the calculated date is added to a field in a table with the ... I shall certainly be more careful with formats in the ... >> I am calculating a future date using the DateAdd function in a query (the ...
    (comp.databases.ms-access)
  • Re: Multiple date formats in a Table
    ... Athough you suggest doing the conversion of my original ... the query on that field... ... historical research, I located a reference for one of my ... Multiple date formats in a Table ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Office 2007 TransferSpreadsheet Import
    ... append/update the table as needed. ... After you have the temp table you can query together what ever you ... To create my Excel document, I'm exporting data from a financial system ... I've also tested using Text & Currency formats. ...
    (microsoft.public.access.macros)