xls report problem

[chandra]

I have data more than 500 characters in one column of the report. I
tried to publish data with word. everything is fine. If I try to
analyze same data with excel. Some of the data is missing in the cell.
Please let me know how to resolve this issue? Here I am using office
links to get data in excel format.

 

[Ken Snell]

I believe Analzye With Excel option uses the old EXCEL 95 format, which
means that it will truncate character strings longer than 255 characters.

If you need to move the data into EXCEL, you'll need to use the
TransferSpreadsheet option (macro or VBA code).

Or, do the analysis inside ACCESS. It can do much of what EXCEL can do.

 

[chandra]

Thank you very much. it resolved the problem.

Chandra