Re: How to export a LONG field to Excel
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 22 Jun 2010 09:08:27 +0200
Message-ID: <4c206175$0$22913$e4fe514c_at_news.xs4all.nl>
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_bright_side_of_wrong/
Date: Tue, 22 Jun 2010 09:08:27 +0200
Message-ID: <4c206175$0$22913$e4fe514c_at_news.xs4all.nl>
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_bright_side_of_wrong/
Or just use different field seperators.
Shakespeare Received on Tue Jun 22 2010 - 02:08:27 CDT