xls report problem

  • Thread starter Thread starter chandra
  • Start date Start date
C

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.
 
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.
 
Back
Top