I'm using 9i heterogeneous services ODBC to load data from Access to Oracle. Works fine except when loading from Access tables with memo fields. Any way to convert them to varchar2? Can't use Long since some tables have multiple memo fields. I can query the fields but errors out when trying to insert/update into oracle.