Exporting files from Access into Excel

[suroora]

I'm not sure whether to put this message in Access or Excel, but here goes.

I exported data from an Access database into Excel (using versions 2002).
One of the fields was a text field. For some reason, when it was imported
into Excel, the field was cropped to 255 characters. Which is fine, if that's
how it does it. But there a couple of cases where it left 285 characters.
Does anyone know why this happens?

Thanks,
Suroor

 

[Jerry Whittle]

I bet that the data type was Memo in the Access table. Here's a good source
for that issue:

http://allenbrowne.com/ser-63.html