Re: HELP (How to export a table to a delimetered text file)

Unfortunately, there isn't an easy way to export the data to delimited file. But you can do this

select col1 || '^' || col2 || '^' || col3 || '^' || col4 from table_name

Spool the output to a file
Open the file using MS-EXCEL, specify '^' as the delimiter. Excel will do the rest for you

Regards

N.Prabhakar

Seigmund Akinwande Johnson wrote:

> Help ,
> Does anyone know how to do this ?

Received on Fri May 07 1999 - 02:25:34 CDT