2004

736 | Chapter 26 Access External Databases
To export data from the Data View window
1 Open a database table by double-clicking it in the dbConnect Manager.
2 Select the records that you want to export from the Data View window.
3 Right-click in any cell, and then choose Copy.
4 Open the external application that you want to export the data to, and
then choose Edit ➤ Paste.
The text is inserted into the external application in tab-delimited format.
Edit Data in a Database Table
If you have opened a table in Edit mode, you can edit its data in a number of
ways. You can add or delete records, or edit a record’s values. You can also
search a particular column for occurrences of a specific value.
Changes that you make to individual records in a table are not written to the
database until you commit them. The Commit option updates the database
table currently loaded in the Data View window with any changes that you
make during an editing session and closes the Data View window. The Restore
option undoes any changes you made in the Data View window during an
editing session and closes the Data View window.
To help you track your editing during a work session, AutoCAD marks changed
records with an edit icon. You can easily review your changes before commit-
ting them to the source database table.
To edit a database record
1 Select a cell to edit in the Data View window.
2 Enter a new value in the cell.
3 Repeat as necessary for any additional cells that you want to edit.
You can use the keyboard arrow keys to move from cell to cell.
To add a new database record
1 In the Data View window, right-click a record header (the empty square at
the left of the row).
2 On the shortcut menu, click Add New Record.
AutoCAD adds a new record with blank field values to the end of the
current record set.