Problem: Out of memory
When joining an Excel Spreadsheet through an OLE DB connection to a shapefile, the following error message occurs:
"Out of memory"
The names defined in the Excel spreadsheet are defined for the whole sheet, rather than defining the name to those cells that contain data.
Solution or Workaround
Redefine the name to just those cells that contain data.