Export to Excel missing text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 28 Mar 2007 16:08 GMT

When export a report from an Access 2000 database to Excel 2000 a notes field
is being randomly truncated i.e. not all the data in that field is being
exported. Has anyone come across this and do you have any idea of a fix?

Reply to this Message

Jerry Whittle - 28 Mar 2007 17:12 GMT

Bet that it's a Memo field and only the first 255 characters are making it to
Excel. If so, here's one answer:

http://support.microsoft.com/kb/208801/EN-US/

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> When export a report from an Access 2000 database to Excel 2000 a notes field
> is being randomly truncated i.e. not all the data in that field is being
> exported. Has anyone come across this and do you have any idea of a fix?

Reply to this Message

Paul - 29 Mar 2007 13:54 GMT

Thats excactly it.
Its easy when you know how!

Many thanks for your help.

> Bet that it's a Memo field and only the first 255 characters are making it to
> Excel. If so, here's one answer:
[quoted text clipped - 4 lines]
> > is being randomly truncated i.e. not all the data in that field is being
> > exported. Has anyone come across this and do you have any idea of a fix?

Reply to this Message