Ah, the ol' cf way - I thought there might be a way directly for the SQL 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 using > the query, and output the info as you like, using CFFILE to append each > 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
