How do I import a table into ArcMap?

How do I import a table into ArcMap?

Adding a Microsoft Excel table to ArcMap

1. Click the Add Data button .
2. Click the Look in arrow and navigate to the Excel workbook file (. xls).
3. Double-click the Excel workbook file.
4. Click the table you want to add to ArcMap.
5. Click Add.

How do I add a table to a shapefile in ArcGIS?

Adding a table to a layout

1. Click the Add Data button.
2. Click the Look in arrow and navigate to the folder that contains the table.
3. Click the table.
4. Click Add.
5. Click the List by Source button on the table of contents.
6. Right-click on the table or layer in the table of contents and choose Open Attribute Table.

How do I add a table to a geodatabase?

Creating a table in a geodatabase

1. Right-click the database in the Catalog tree in which you want to create a new table, point to New, then click Table.
2. Type a name for the table.
3. Click Next.

Can a Microsoft Access table be used in ArcGIS?

You can use tables from a Microsoft Access database in ArcMap through an OLE DB connection. OLE DB is a standard for sharing data between applications, enabling you to view the Access database in ArcMap. To maintain data integrity, you should only modify an Access database in Access. Similarly, you should only edit a personal geodatabase in ArcGIS.

How to view Microsoft Access database in ArcMap?

OLE DB is a standard for sharing data between applications, enabling you to view the Access database in ArcMap. To maintain data integrity, you should only modify an Access database in Access. All Microsoft Access databases (.mdb) are shown and you can browse to them using ArcCatalog or the Catalog window.

Can a linked table be viewable in ArcGIS?

Access tables, like other tables without associated features, are only viewable when the ArcMap Table of Contents window is listed by source. Linked tables in Access are not viewable through an OLE DB connection, although Access queries are available.

How to add OLE DB connections in ArcGIS?

In ArcCatalog, open the Database Connections folder, and double-click ‘Add OLE DB Connections’ to open the Data Link Properties dialog box. Note: Refer to FAQ: Where is the ‘Add OLE DB Connection’ command in ArcGIS Desktop 10.1? to add OLE DB Connections for ArcGIS 10.1 and above.