English

How To: Add an Excel table to ArcView using SQL

Summary

You can add Excel tables directly to ArcView through a SQL connection. First, create a Data Source Name (DSN) for the database. Then use ArcView's SQL functions to add the table to the project.

A DSN is a user-configured set of connection parameters created within the Open Database Connectivity (ODBC) Administrator. ODBC is a component of all Windows operating systems. It allows diverse applications to exchange tabular data, similarly to a Universal Translator.

Procedure

 

  1. Create a DSN for the Excel database.
     
    A. Click Start > Settings > Control Panel.
    B. Double-click the ODBC32 Administrator.
    Note:
    If the ODBC Data Source Administrator does not appear in the Control Panel, click Start > Run, type odbcad32, and click OK to open the ODBC Data Source Administrator.
    
    C. Select the User DSN tab, then click the Add button.
    D. Select the Microsoft Excel Driver and click Finish.
    E. Click Select Workbook.
    F. Select the XLS file and click OK.
    G. Type in a name for the DSN in the Datasource Name field, for example, Customers
    H. Click OK.
    I. Click OK to close the ODBC Administrator dialog box.
  2. Make a SQL connection to the Excel database DSN.
    A. Start ArcView.
    B. Select SQL Connect from the Project menu.
    C. Select the Data Source Name (DSN) from the Connections scrolling list.
    Note:
    You may need to restart ArcView before new DSNs appear in this SQL Connect dialog box.
    D. Click Connect. Type in User Name and Password if necessary.
    E. Double-click the table in the Tables list.
    F. Double-click the desired columns From the Columns list.
    G. Enter a name for the new ArcView table in the Output table field.
    H. Click Query.

Related Information