I fixed (kinda) my problem by truncating my records to 250 chars.

I'm automating the creation of my database and table definition using VB
Script.

When I use the UI I see there is another datatype called memo. However, when
I look at http://msdn.microsoft.com/en-us/library/ms675318(VS.85).aspx I
don't see such a datatype.

Will using type memo alleviate the 255 character constraint? How big can
memos be?

What is the number value for the constant adMemo

Siegfried Heintze wrote:

So this must be an Access (Jet) database? Are both the source and
destination databases Access?

Right. It's an access-specific name. The corresponding JetSQL name is,
confusingly, "TEXT". The JetSQL name for the Access "Text" datatype is
"CHARACTER" ("CHAR" can also be used).