Re: EXPORTING FROM ORACLE V7 TO MS EXCEL

You can skip several steps by including the MS-Query option in the Excel/Office setup. Then you just make a query to an ODBC data source. The results will always be in your excel spread sheet. If the database table is updated between spreadsheet opens, your spread sheet will have the latest values.

The other way I do what you ask is to have a column of commas:

spool c:\temp\whatever.csv
select field1||','|| field2|| ','|| field3 from table; spool off

Since you're opening a CSV file, the fields will already be delimited. I'm assuming you installed PLUS80.EXE on your PC.

--rn.

David Haynor <haynor_at_u.washington.edu> wrote in message news:7nio9j$7ua$1_at_nntp6.u.washington.edu...
> hi oracle wizards,
>
> i'd like to make a query, and then export the results, with tabs between
> columns and newlines between rows, to a file readable by MS Excel.
> i believe that i can use SPOOL to do this, but how do i set the column
> separator to a tab?
>
> more generally, are there better ways to save the results of a query in
> an external file?
>
> thanks in advance.
>
> -dh
> -david haynor (haynor_at_u.washington.edu)
> department of radiology
> box 356004
> university of washington
> seattle, WA 98195
> (206) 543-3320
>
>
>
Received on Sun Aug 01 1999 - 17:16:20 CDT