Field Truncation

  • Thread starter Thread starter ty
  • Start date Start date
T

ty

When I import data to my table, the macro generates an
error table that lists the records that contained
errors. All the data in all the fields does import. The
errors occur on the Description field, which is a memo
type. But the error says "Field Truncation". How do I
fix this? Or how do I keep Access from creating these
error tables (more than anything they annoy me.)
 
I've read of this kind of problem quite a number of times in the
newsgroups... I don't know if there is a workaround to import the whole
text, but from your post I sense that you can live with the truncation? In
that case, I can offer a solution to get rid of the paste errors:
Make a query on the table including every other field, and istead of the
Description field per se, use a caclulated field to return the 255-character
long leftmost part, i.e. Descr: Left([Description],255). Then append from
this query, rather than directly from the table.
Following that, you could also change the field type in the destination
table to text, length 255 (max. for text fields).

HTH,
Nikos
 
Back
Top