2011

When you view and edit data from an ODBC database, you can do the
following:
■ Select the feature classes to include in your map.
■ Set conditions to limit the features in your map.
■ Style, theme, and edit the features.
■ Lock the file when you connect to it.
■ Automatically update the data source with any edits you make.
Your edits are immediately visible to anyone else using the data source.
■ Define feature classes for any relational database table with X, Y (and,
optionally, Z) columns. Object locations are stored in separate properties
in the object definition of a feature, which is accessible through the
Geometry class property. You cannot create or delete feature schemas.
Microsoft Excel Data
To access Microsoft Excel data, you must define table ranges in Excel. These
named ranges in the worksheet can then be treated as separate ODBC tables,
with each one mapping to an
FDO (page 2062) feature class. If you do not define
named ranges, no feature classes are available to add to your map. Instructions
for defining a table range are on the Procedure tab of this topic.
Microsoft Access Data
Some Microsoft Access databases have autogenerated primary keys. You can
load data from Microsoft Access databases without these primary keys and
use that data for joins, and so on, However, without a primary key you cannot
create and update data.
To perform a AutoCAD Map 3D location query in a Microsoft Access database
that contains long integer values (longs), use the tools in Access to remove
the indexes from location-based x/y columns.
NOTE For information on customizing this provider, refer to the FDO API Reference
and the FDO Provider for ODBC API Reference.
Tell me more
Video
■ Show me how to bring in point data
from an ODBC database.
Accessing Data from ODBC | 343