I'm trying to load an Access 2010 database into Arc Catalog through an OLE DB connection using the OLE DB Provider "Microsoft Office 15.0 Access Database Engine OLE DB Provider". Tow of the tables in the Access database contain memo fields (unlimited character length). The database loads/connects correctly but attempting to preview the two tables with memo fields in Arc Catalog I get an error. In Access converting the Access memo fields to Access text fields that have a limited length of 255 solves the problem. Those two tables preview correctly. However I lose data in those fields that were beyond the limit of 255 characters. Does anyone know how to correctly load memo field types? There is no clear segment where splitting the fields would yield meaningful fields so I'd prefer not to attempt that approach.
Thank you for any help you can provide.