Formatting a table in Microsoft Access for use 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.

Make sure your field names are properly formatted. You should follow these general best practices for field naming, particularly if you want to join an Access table to another table in ArcMap:

If you import a table into a database in Access, follow these guidelines when using the wizard:

Related Topics