Continue in the app
Be The First To Get Support Updates
Want to know about the latest technical content and software updates?

Problem: Unable to preview certain FoxPro tables in ArcCatalog using an OLE DB connection


Some of the tables can't be previewed after the OLE DB connection is made in ArcCatalog using the OLE DB provider for ODBC sources and the Microsoft Visual FoxPro driver. The field names are listed in the preview window but no rows are visible.


If the FoxPro table includes a memo field, the data in the table will not display correctly. This is a known issue using the Microsoft OLE DB provider for ODBC sources.

Solution or Workaround

Try one of these workarounds:

  • Export the table to dBASE(IV) format.
  • If the connection is to a FoxPro database, create a view of the table without the memo field.

Last Published: 5/5/2016

Article ID: 000002703