Memo Cut Off When Exporting to Excel using Outputto Function

[Guest]

I have created an interface that allows you to export a report in Excel. I
have created a simple select query that is executed and exported to Excel
using the DoCmd.Outputto command. When opening the excel file, I noticed
that the values under the description column would be cut off. This
description is a memo field in the table. The funny part is that it is very
inconsistent, sometimes it will export the full description, sometimes it
will cut off. Any help you can provide would be greatly appreciated.

 

[Guest]

Angel:

How long is a sample text field that completely exports? How long is the
text in one that was cut off?

You may be hitting a limit of some sort, though I tested out a good 1500+
characters, in a single cell, with no problem.

Sharkbyte

 

[Guest]

Thanks for getting back to me. I was looking at the excel spreadsheet and it
actually cuts off at 255 characters. Not sure why it's doing that as the
Description field is a Memo data type.

Your help is very much appreciated.

 

[Guest]

With the 255 character limit it sounds like Access is seeing the report field
as a text box. I looked, and don't see a way to designate it as a memo data
type.

Ah, I actually found something through Microsoft Help. Amazing! =) Try
this link:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;294286

Sharkbyte

 

[Guest]

Thanks for the link. I will try this out. I appreciate your help on this.