linked table truncates data

[Guest]

Hi

I have a database that contains a table linked to an Excel spreadhseet. The
linked table has a field called "Comment" which is a memo data type. This
field is fairly constantly as I work with the data. My problem is that as I
update the linked table with the comment field, it truncates the comments at
255 characters. I've looked into what the database is doing, but don't think
it is a problem with my data types. the truncation appears to happen
someplace in the interface between Access and Excel.

I don't know anything about Jet or how to manipulate it, but I think this
might be where the problem lies.

Any ideas?

 

[Rick B]

This is asked and answered pretty often. You should do a search and look at
previous posts. I know one reason this happens is if you are sorting by
that field. If you sort on a memo field in a query, it will truncate the
data. If it did not, it would take forever to build the query results.

Another reason this can happen is if you apply any formatting.


http://groups-beta.google.com/groups?q=access+query+memo+truncate


Rick B

 

[Ken Snell [MVP]]

Known issue. See this Knowledge Base article for more details.
http://support.microsoft.com/default.aspx?scid=kb;en-us;839785