English

How To: Define tables in a Microsoft Excel spreadsheet

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.