The memo field should work fine with an ODBC connection. But it could always be an issue with your particular ODBC driver, and of course I've not tested across versions, etc.
If the memo field is the only column that consistently causes the load to fail, perhaps you can string converting the type to string. You could do this by calling CStr() in your SELECT (again, assuming you are using ODBC against MS-Access), so something like this:
SQL SELECT
CStr(MyMemoField) As MyField
FROM Table1;
Or you could do this in your MS-Access database as a query, then just SELECT the query instead of the table.
