Report Export to Excel Memo field truncates (512 chars).

[mccalla]

Hi,

I am very new to MS Access. I have inherited an existing app which was done in MS Access 2003. In this app, there is a report which contains a memo field. There are no formats, functions, unions, or anything. It is populated from a simple select. The problem is....when the user exports the report to excel, it seems to be truncating this memo field after 512 chars. After that, there appears funny chars that look like tiny squares.

Excel is 2000. When I do save, I save file using Microsoft Excel 97-2003(xls).

I need to get this solved ASAP. Any solution would be appreciated.

Thanks in advance,
mccalla

Remember, I am a newbie.

[mccalla]

Hi,

Ok... Let's add to the mystery.
Here's is what I found so far.
If I go into the table in DataSheet View and do a File/Export .... Save As
Microsoft Excel 97-2003....etc.
Memo Field exports to excel beautifully.
HOWEVER...... if I am in DataSheet View and do a Tools/Office Links /
Analyze with Excel - Problem occurs in Memo field.... truncates after
512 ... and I noticed it replaces squares for the remaining text.
Weird...huh?

Next, I created a query.... all it does is 'select * from table'. Same results
as above.

When I have a report, no matter which way I export File/Export or Tools/Office Links / Analyze with Excel - neither way works.

I hoping these results may ring a bell to someone with more experience with MSACESS 2003 than me.

I hoping there is a user-friendly fix for this.

Thanks in advance,
Mccalla

[Nathan H]

Can you export as csv file and then open with Excel. This should stop the truncation of the field.