HOW TO

Define tables in a Microsoft Excel spreadsheet

Last Published: April 25, 2020

Summary

A single Microsoft Excel spreadsheet can contain multiple tables. In order for ArcView or any ODBC client application to see those tables when you make the ODBC connection, those tables must be defined in the spreadsheet. Below is the procedure for defining tables in an Excel spreadsheet

Procedure



  1. Open up the spreadsheet in Excel. Highlight the block of cells that will represent a single table in ArcView.
  2. From the Insert menu, click Name, then click Define. This will bring up a menu where the name of the block can be defined.
  3. Type in the name to be assigned to the highlighted cells, then click OK. This is the name that will appear in the tables list on the SQL connect window in ArcView.

    You may define several tables this way in the same worksheet. A drop down list of the tables defined in a single worksheet appears above the upper left corner of the worksheet.

Article ID:000001774

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic