Drill down to the table and right click on it, under all tasks > export data
. Follow the wizard, on the second step you will be able to chose your
destination. Select text file. Then there are other options...
Good luck,
Alexander Sicular
Chief Technology Architect
Neurological Institute of New York
Columbia University
as867 [at] columbia {dot} edu
|-----Original Message-----
|From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
|Sent: Wednesday, February 20, 2002 6: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
