Exporting to ODBC
You can export model component data to an ODBC (Open Database Connectivity) database. The exported
data can include project parameters that have been assigned to one or more element categories in the project.
For each element category, Revit Architecture exports a database table for model types and another table for
model instances. For example, Revit Architecture creates a table listing all door types and another table
listing all door instances.
ODBC export uses metric units only. If a project uses Imperial units, Revit Architecture converts all
measurements to metric units before exporting to ODBC. When you use data from the resulting database,
remember that the measurements reflect metric units. Use a database function to convert the measurements
back to Imperial units if necessary.
Using ODBC, Revit Architecture creates tables for the following elements:
■
Model Objects: Types and Instances
■
Levels and Rooms: Instances only
■
Key Schedules
■
Assembly Codes: A single table containing assembly code data for the entire project
ODBC export creates specific relationships between tables in the database using primary keys and reference
values. See
Table Relationships Within the Database
on page 1289.
Revit Architecture can export to the same database multiple times. When exporting to an empty database,
Revit Architecture creates new tables. When you export a project to a populated database, Revit Architecture
updates table information to match the project. This allows you to customize the database and re-export
data as the project changes.
IMPORTANT
Do not export different projects to the same database. Use a unique database for each project.
Supported ODBC Drivers
ODBC is a general export tool that works in conjunction with many software drivers. Revit Architecture has
been tested with the following ODBC drivers:
■
Microsoft
®
Access
■
Microsoft
®
Excel
■
An ODBC export to Excel creates one table per worksheet.
■
You can export to an Excel file only once. Multiple exports to Excel are not supported.
■
Microsoft
®
SQL Server
■
The Microsoft
®
Text Driver is not supported by Revit Architecture.
Revit Architecture may be able to work with other ODBC drivers, depending on the features supported by
the driver. If you need assistance with a particular software driver, contact your local IT department or
Autodesk Product Support.
Exporting to ODBC | 1287
Summary of Contents for 24000-000000-9860 - Revit Architecture - PC
Page 1: ...Revit Architecture 2009 User s Guide April 2008 240A1 050000 PM02A ...
Page 4: ......
Page 56: ...18 ...
Page 116: ...78 Chapter 3 Revit Essentials ...
Page 172: ...134 Chapter 4 ProjectViews ...
Page 178: ...Schedule with Grid Lines Schedule with Grid Lines and an Outline 140 Chapter 4 ProjectViews ...
Page 554: ...516 ...
Page 739: ...Curtain wall Curtain Grid Curtain Walls Curtain Grids and Mullions 701 ...
Page 1004: ...966 ...
Page 1136: ...1098 ...
Page 1226: ...1188 ...
Page 1250: ...1212 ...
Page 1276: ...1238 Chapter 20 Design Options ...
Page 1310: ...1272 ...
Page 1366: ...1328 ...
Page 1406: ...1368 ...