I posted what I think is an elegant solution to the 911 character limitation
in Excel. Perhaps it will work in Access as well.

http://support.microsoft.com/newsgro...sloc=en-us&p=1

"Ken Valenti" wrote:

When using the CopyFromRecordset method, it fails if the lenghth of text
exceeds 9XX.

Using ADO to connect to an Access 2003 database. Fields are defined as
"memo" in Access (unlimitted length).