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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: TomTom (no_spam_please_at_tomtom.com)
Date: 03/20/04 

Date: Sat, 20 Mar 2004 09:47:50 -0800

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: Macro
    ... Then post the query results. ... My data is in an Excel file called ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ... VBA code in excel suddenly became un-compileable. ...
    (microsoft.public.excel.programming)
  • Re: Excel Calcs in Access
    ... show below looks to me like an Excel sheet with one column of ... "John Nurick" wrote: ... below is the result of the same query but 1 line above. ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.modulesdaovba)
  • Re: Looking for Easiest Way to Create Report
    ... By recording Excel macros and editing them you may be able to get all this down to one button push in each application. ... run your query then that makes life very much easier than it would have been if you'd had to match values line by line. ... So, if you do go for the query and TransferSpreadsheet route, that leaves you with the problem of levering in the four header rows. ... My guess is that the simplest solution will be in Excel, if you're prepared to do the job in two stages: one which generates the spreadsheet from Access, and another which requires you to move to Excel to add the headers. ...
    (microsoft.public.access.gettingstarted)
  • Re: EXCEL Issue retriving data from SQL
    ... I got the same results, one row in analyzer, and two in EXCEL. ... ' Establecer el query o stored procedure a ejecutar ... Dim lngRenglon As Long ...
    (microsoft.public.excel.programming)
  • Re: OutputTo to Excel question
    ... "Jeanette Cunningham" wrote: ... As you note it forces excel to treat numbers as text. ... clicks Ok and your query is exported) ... Save a query that pulls the same data as the report. ...
    (microsoft.public.access.macros)