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.