Page 1 of 1
Exporting Character fields
Posted: Thu Jul 18, 2002 1:54 pm
by Suzanne1975
Hello. I am having a problem exporting a character field into Excel. When the report is exported as a .wks file, the character field is cut off in Excel and stops after 255 characters. However, in Excel you can type an unlimited amount of information into one cell. Do you have any suggestions regarding exporting character fields with data greater than 255 characters into Excel? Please let me know your thoughts on this. Thanks.____-Sue__
=> RE: Exporting Character fields
Posted: Thu Jul 18, 2002 6:15 pm
by kfleming
R&R will not export more that 255 characters to a single field. There is no way around this restriction I am afraid.____Kathleen__R&R Support
==> RE: Exporting Character fields
Posted: Fri Jul 19, 2002 6:50 am
by Colin_Dow_(Guest)
Depending on the info you have and how often you run the report a work around might be to split the field either as part of your source query or in R&R__(I cant check this as my database ony stores 255 chars max)__You would then export to multiple cols__i.e. __Char 1-255 column 1__Char 256-510 column 2__etc. __You would need to check ahead of time to see what the maximun number of columns required would be. __Once in excel you could concatenate columns into one and delete the work columns.__