The ODBC provider connects to databases such as Microsoft Access, and Microsoft Excel. An ODBC database contains points, which are typically specified either by Latitude and Longitude columns or by arbitrary XY coordinates. For example, a database “State” contains tables for “Cities” and “Villages,” each of which has columns LAT and LON to define the position of the point features.
ODBC databases do not store feature classification. However, you can define feature classes when you configure the data source. By default, the ODBC Provider maps each table in the database to a “feature class” while each column becomes a “property.”
If your data is in Microsoft Access or Excel format, you can upload the source files to the site server from any location in your file system. You can also download the files from the server to your file system for update and replacement.