I have seen this before using VBScript & Access (I don't use VB much). That error usually indicates either a data type issue or a field length issue. Sounds like you have the data type covered. Check the field length in the source & destination fields to make sure that you aren't potentially trying to put data that is too large for the field into the destination.
Sorry about that - had a momentary lapse of reason. Forgot for a moment that you specified field length by setting type to memo.
Sounds like for troubleshooting you may want to step through the recordset one by one to find the offending record(s), then you can inspect that individual record to determine why it failed. I still think there may be a schema difference between the 2 tables causing some grief. Perhaps a field in the source table that allows zero-length data while the corresponding destination field doesn't?