Hi Kelly,
Go To Query Analyzer and query the table you wish and The result fo
r
that Query is shown in result pane below,
There by you can select the result set Right Click you have options of S
ave
AS,
1. Here you can save it as CSV file
2 Select ALL and copy and Paste it on any text file.
Cheers!
Regards
Nagaraj
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 21, 2002 5:00 AM
Subject: Re: Export to text
> Ah, the ol' cf way - I thought there might be a way directly for the SQ
L
> Server Enterprise Manager.
>
> ----- Original Message -----
> From: "Lee Fuller" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, February 20, 2002 4:22 PM
> Subject: RE: Export to text
>
>
> > Sure..
> >
> > Do a query that pulls all the data out of the table. Run a CFLOOP us
ing
> > the query, and output the info as you like, using CFFILE to append ea
ch
> > row to the text file.
> >
> > Piece'o'cake.
> >
> > ;)
> >
> > Lee
> >
> >
> > | -----Original Message-----
> > | From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > | Sent: Wednesday, February 20, 2002 3:19 PM
> > | To: CF-Talk
> > | Subject: Export to text
> > |
> > |
> > | Can anyone tell me how to export a sql server table to a text
> > | file (each column seperated by pipes and data incased in
> > | double quotes)?
> > |
> > | Thanks!
> > |
> >
>
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
