Point data is often used in engineering projects. X, Y, and Z coordinates of assets and structures such as inlets, outlets, and manholes can be captured directly in digital format using a GPS or other data-collection device. Other attributes of the various structures, such as type, condition, and age may be noted manually by survey crews in their field books. The coodinates are stored as columns in a database table. The attributes of the various structures can be entered into the database as well.
Microsoft® Access (.mdb) is a common format for storing this kind of point data. However, spreadsheets in formats such as Microsoft Excel (.xls) are widely used as well. You bring this data into AutoCAD Map 3D in the same way, using the provider for ODBC. (ODBC stands for Open DataBase Connectivity.)
The simplest way to connect to an ODBC database is through a system DSN (Data Source Name) that you have already defined. It is very easy to define a DSN using the Windows Control Panel/Administrative Tools/Data Sources (ODBC).