FAQ: Why Doesn't My Excel Data Appear under an OLE DB Connection Object?

Answer

A Microsoft Excel worksheet is exposed by the data source as an OLE DB SYSTEM Table not OLE DB Table. As OLE DB connections in ArcGIS return only Table and View objects, worksheets will not appear when you expand the OLE DB connection to the worksheet.

You must define a named section in the Excel worksheet; this will be exposed as an OLE DB table to ArcGIS.

Article ID:000002611

Software:

ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Connect to an Excel spreadsheet in ArcCatalog

Why doesn't my Excel data appear under an OLE DB connection object?

Answer

Related Information

Discover more on this topic