Thanks! This worked. ----- Original Message ----- From: "nagraj" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 10:39 PM Subject: Re: Export to text
> 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! > > > | > > > > > > ______________________________________________________________________ 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=coldfusiona 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
