Re: EXPORTING FROM ORACLE V7 TO MS EXCEL

David Haynor wrote:

> 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?

Someone else mentioned using MS-Query and ODBC, which is an excellent method if it's all configured properly.

The approach that I use most often with Excel is to spool the output, then import it as a fixed-column file. Excel is pretty good about figuring the column breaks from the dashes that Oracle inserts after the header row.

One thing that makes this easier is to use the following to commands before spooling (increase either as needed to avoid splitting lines or inserting extra headers):

    set linesize 1024
    set pagesize 1024

-kdg Received on Wed Aug 04 1999 - 13:12:00 CDT