Re: Large numeric values exported from Oracle to Excel

You could consider to use SQL*XL. Use SQL*XL to load the data directly into Excel. It should not drop the significant digits from your numbers.

SQL*XL specialises in dealing with databases from MS Excel. It works with all databases and has been tested to work fine against Oracle, Access, Foxpro, SQL Server, Sybase, etc etc

SQL*XL is full featured. You can use Excel cells in the SQL, it supports macro recording, VBA coding, scripting, comes with an installer/uninstaller and has a help system.

Find SQL*XL at www.oraxcel.com

I suggest you download both SQL*XL3 and SQL*XL ADO

Kind regards, Gerrit-Jan Linker
"nmccullough" <member_at_dbforums.com> wrote in message news:1787781.1031451938_at_dbforums.com...
>
> Hi, I'm new to Oracle and have encountered a problem that did not happen
> with MS SQL. When I export large numeric values from Oracle (using
> Toad or SQL Plus Worksheet), the values appear as to the nth power
> instead of a numeric string. (exported in csv or tab delimited or pipe
> delimited)
>
> When the values are imported into Excel, they are rounded and the unique
> identifier is lost.
>
> Please advise.
>
> Thank you
>
> --
> Posted via http://dbforums.com
>
Received on Sun Nov 10 2002 - 10:59:55 CST