Is This Content Helpful?
We're glad to know this article was helpful.
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.
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.
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.