Re: How to export a LONG field to Excel

From: joel garry <joel-garry_at_home.com>
Date: Tue, 22 Jun 2010 13:23:04 -0700 (PDT)
Message-ID: <9a066d12-e1bb-4392-a45f-5916f4f9d318_at_c10g2000yqi.googlegroups.com>

On Jun 22, 12:08 am, Shakespeare <what..._at_xs4all.nl> wrote:
> Op 22-6-2010 1:45, joel garry schreef:
>
>
>
> > On Jun 17, 10:49 pm, "dn.p..._at_gmail.com"<dn.p..._at_gmail.com>  wrote:
> >> I use Oracle SQL Developer, ver 2.1, to access an Oracle 10g server. I
> >> would like to export a LONG field into an excel sheet. Sometimes it
> >> works, sometimes not, and I have not been able to find out the
> >> boundary beyond which it fails. I can export it into a csv file and
> >> then open it an an excel file, but the LONG field contains several
> >> tabs and several commas within it. And formatting that data correctly
> >> so that excel organizes it the way I want (correct field in correct
> >> column) is proving a bit tiresome.
>
> >> Can Oracle SQL Developer or TOAD be configured to read (say) 2,000
> >> characters of a LONG field, truncate the rest, and reliably export
> >> this data (with a limit of characters in a LONG field) into an Excel
> >> sheet?
>
> >> Please advise; thanks in advance.
>
> > Also note you can protect commas and tabs with double quotes, as you
> > could see by saving excel files as csv's.
>
> > jg
> > --
> > _at_home.com is bogus.
> >http://www.boston.com/bostonglobe/ideas/articles/2010/06/13/the_brigh...
>
> Or just use different field seperators.
>
> Shakespeare

How many ways does Excel blow? Don't get me started...

jg

--
_at_home.com is bogus.
http://thedailywtf.com/Articles/A-Gracious-Grace-Period.aspx

Received on Tue Jun 22 2010 - 15:23:04 CDT