English

How To: Add an Access table to ArcView using SQL

Summary

Access tables can be added directly to ArcView through a SQL connection. This is done by creating a Data Source Name (DSN) for the database, and then using 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. The 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 Access Database.
     
    A. Click Start > Settings > Control Panel.
    B. Double-click the ODBC32 Administrator.
    C. Select the User DSN tab, and click Add.
    D. Select the Microsoft Access Driver and click Finish.
    E. Click Select.
    F. Select the MDB file and click OK.
    G. Type in a name for the DSN in the Datasource Name field, for example, Addresses.
    H. Click OK.
    I. Click OK to close the ODBC Administrator dialog box.
 
  1. Make a SQL connection to the Access 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