By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,965 Members | 1,136 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,965 IT Pros & Developers. It's quick & easy.

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

P: 4

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,

Remember, I am a newbie.
Jan 23 '08 #1
Share this Question
Share on Google+
2 Replies

P: 4

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.

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,
Jan 24 '08 #2

Nathan H
P: 104
Can you export as csv file and then open with Excel. This should stop the truncation of the field.
Jan 24 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.