Truncated fields when Report analyzed in Excel

[jlybn]

Hi there,

I'm having problems when I "analyze" my reports in Excel. Some of the
fields which contain a large amount of data (eg. > 400 characters text) are
truncated. All the data displays when i view the report in Access. However,
when i "analyze"/export to excel, i lose the later portion of the data.

I can still type further characters in the Excel cells, once the data has
been moved, so it doesn't seem to be a limit inherent to Excel.

Can anyone please help???

thx so much!
~jenn
I can not find how to increase the amount of data which will m

 

[Allen Browne]

There is a problem with exporting fields longer than 255 characters.

See these knowledgebase articles:
- Memo Field Truncated When Report Is Output to Excel:
http://support.microsoft.com/kb/208801

- When You Export an Access Report the Memo Field Is Truncated:
http://support.microsoft.com/kb/281153

- Exported Query Expression Truncated at 255 Characters:
http://support.microsoft.com/kb/207668

 

[jlybn]

Hi Allen,

Thanks for your response. Do you know if the "Service Pack" (276367
(http://support.microsoft.com/kb/276367/EN-US/) OFF2000: How to Obtain the
Latest Office 2000 Service Pack ) referred to in your second searchable
article is available for MS Access from Office 2003?

This solution sound like it would be best for my puposes, but only if its
available for the version of Access that i'm running.

Thanks!

~ Jenn

 

[Allen Browne]

For info on how to get the SP for Office 2003, see:
http://support.microsoft.com/kb/870924