Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Showing so many characters cutting off the rest (Read 2300 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Showing so many characters cutting off the rest
07.11.07 at 21:05:24
 
Showing so many characters cutting off the rest
 
A customer wrote the following to me:
 
I love the software.  Its made my life alot easier.
 
One question - when I download data into excel, it only shows so many
characters and cuts off the rest.  How can I get it to bring in all the
content into the excel cell?
 
Thanks.
 
Answer:
> For long (datatype long) there is a limit. Please try this:
>
> In th sql dialog type this command:
>
> Set long 1000;
> Select...
>
> For long columns which can contain 2GB of data the first 1000 characters
are shown. If you want more characters just increase the number.
 
See also:
select data from Oracle long columns  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1171443472/0
Control how Long Varchar columns are displayed
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1135939951
SQL*XL: Set command
http://www.oraxcel.com/projects/sqlxl/help/commands/set.html
Back to top
 
« Last Edit: 07.11.07 at 21:09:15 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1