Lesson 2: Analyzing Data With External Information Using Joins
Lesson 2: Analyzing Data With External Information Using Joins
Exercise 2: Connect to the Access database
AutoCAD Map 3D Tutorials > Tutorial: Analyzing Data Using Styles, Joins, and
Buffers > Lesson 2: Analyzing Data With External Information
Using Joins >
Exercise 1: Set up an ODBC connection for an Access database
Set up an ODBC connection for the Access database using the Administrative Tools control panel in Windows.
NoteThis exercise uses the AnalyzeMap1.dwg map you created
and modified in the previous exercises.
To set up an ODBC connection for the Access database
- From
your Windows desktop, click Start menu
Settings Control
Panel and open the Administrative Tools control
panel. - In the Administrative Tools window, double-click Data Sources (ODBC).
- In the ODBC Data Source Administrator dialog box, click Add.
- In the Create New Data Source dialog box, click Microsoft Access Driver (*.mdb) and click Finish.
- In the ODBC Microsoft Access Setup dialog box, for Data Source Name, enter Parcel_Owners.
- Enter
a description, for example, "Parcel owner information."
Name the data source.
- Under Database, click Select.
- In
the Select Database dialog box,
navigate to the sample files and select the Assessor.mdb file.
Specify the database for this data source.
- Click OK in the Select Database, ODBC Microsoft Access Setup, and ODBC Data Source Administrator dialog boxes.
- Close the Administrative Tools control panel.
To continue this tutorial, go to Exercise 2: Connect to the Access database.