Exporting to an ODBC Database
The first time that you export a Revit Architecture project to an ODBC database, use the following procedure.
If you have already exported the project and want to re-export it, see
Exporting Multiple Times to the Same
ODBC Database
on page 1288.
To export to an ODBC database
1
In Revit Architecture, open the project to export.
2
Click File menu
➤
Export
➤
ODBC Database.
3
Click New to create a new Data Source Name (DSN).
4
In the Create New Data Source dialog, do the following:
a
Select a driver and click Next.
This driver is associated with the software program you export to (for example, Microsoft
®
Access, dBase, or Paradox).
b
Enter a DSN name, or navigate to the target folder and specify a file name. Click Next.
c
A confirmation dialog displays. If any information is incorrect, click Back and correct it.
d
Click Finish.
5
Create the database file.
Depending on the driver selected, a dialog displays, requesting information about the database
file to export to. Use the dialog to specify the database to use or to create a new one. For example:
■
For Microsoft
®
Access, click Select to select an existing database, or click Create to create a
new, empty database to export data to.
■
For Microsoft
®
Excel, first use Excel to create a new, empty workbook with the desired name.
Then on the dialog, click Select Workbook, and navigate to the new workbook.
6
In the Select Data Source dialog, click OK.
7
In the ODBC Setup dialog, click OK.
NOTE
If the export fails with an error regarding a read-only database, click Options in the ODBC Microsoft Setup
dialog. Clear the Read Only check box. Then try the export again.
Exporting Multiple Times to the Same ODBC Database
1
In Revit Architecture, open the project to export.
2
Click File menu
➤
Export
➤
ODBC Database.
3
In the Select Data Source dialog, select the desired data source, and click OK.
4
In the ODBC Setup dialog, click OK to export to the same database.
Editing the Database After Export
Do not edit data in the database columns exported by Revit Architecture. Any changes to those columns
are overwritten the next time the project is exported.
However, you can add columns to the tables created by Revit Architecture. The next time the project is
exported, any data in the added columns is preserved.
1288 | Chapter 22 Interoperability
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 ...