Re: EXPORTING FROM ORACLE V7 TO MS EXCEL

From: <gjlinker_at_geocities.com>
Date: Tue, 03 Aug 1999 17:05:46 GMT
Message-ID: <7o77h0$pbh$1@nnrp1.deja.com>

You'll be delighted to read that I've written a program to do all this and that it is freely available for download (the LITE version that is).

Oraxcel is an addin for MS Excel and it allows you to use Excel as front-end to Oracle databases. No hassles with ODBC reformatting and other daunting issues. Just straightforward SQL and it fetches it all, neatly formatted, into Excel.

Have a look at Oraxcel at http://members.aol.com/gjlinker

There is loads of demo material and you can download the free LITE version from here.

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

Regards, Gerrit-Jan Linker
Developer of Oraxcel, OraDebug, OraCodes, OraSQL and OraWeb http://members.aol.com/gjlinker

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 03 1999 - 12:05:46 CDT