Copy, paste, delete, and edit tables in the electrical standards database file for Circuit Builder.
Note: For capabilities not provided by the electrical standards database editor, use Microsoft Access.
Open and Close a Table
- Select the table you want to open.
- Right-click and select Open on the context menu.
Note: You can also double-click a table name to open it.
- To close a table, move the mouse over the tab for the table. An X is displayed. Click the X.
- Select Yes to save the changes if prompted.
Edit a Table
- Select the table you want to open.
- Right-click and select Open on the context menu.
Edit contents
- Click the cell to edit and type to overwrite the contents.
Double-click the cell to edit the contents.
- Click Save.
Add a record
- Click to the left of a row to highlight a row.
- Right-click to display the context menu.
- Click Add New Record.
The new record is added at the end of the table.
- Enter values in each cell of the new row.
- Click Save.
Delete a record
- Click to the left of a row to highlight a row.
- Right-click to display the context menu.
- Click Delete Record.
- Click Save.
Copy and paste
- Click to the left of a row to highlight a row.
- Right-click to display the context menu.
- Click Copy.
The contents of the row are placed in memory.
- Right-click to display the context menu.
- Click Paste.
The copied record is added at the end of the table.
- Edit the contents of the cells.
- Click Save.
Add a column
- Click a column label.
- Right-click to display the context menu.
- Click Insert Column.
The Insert Column dialog box displays.
- Enter a name for the column.
- Select the column type, Text, or Number.
- Click OK.
The column is added at the end.
- Enter the cell values.
- Click Save.
Note: Columns can only be added to the AMP, INSUL, MOTOR_I_CALC, and XL&R tables.
Delete a column
- Click a column label.
- Right-click to display the context menu.
- Click Delete Column.
The Delete Column task dialog displays.
- Click Yes.
Note: This change is written to the database file immediately and cannot be canceled or undone.
Note: Columns can only be deleted from the AMP, INSUL, MOTOR_I_CALC, and XL&R tables.
Sorting
- Double-click a column to sort by the contents of that column.
Note: Sorting is temporary and is not saved to the file.
Delete a table
- Select the table you want to delete.
Note: Use the shift or ctrl keys to select multiple tables.
- Right click and select Delete on the context menu.
The Delete Tables task dialog displays.
- Click Yes.
Note: This change is written to the database file immediately and cannot be canceled or undone.
Copy and Paste a Table
- Select the table you want to copy and paste.
Note: Use the shift or ctrl keys to select multiple tables.
- Right click and select Copy on the context menu.
- Right click again and select Paste.
The Copying Table dialog box displays.
- Enter the name for the new table. If multiple tables were selected to copy, enter a name for each table as prompted.
To paste a table into a different electrical standard, add the appropriate suffix to the table name. For example, if you want to paste the default OPT table to the NEC standard, enter the name OPT_NEC. If the NEC standard does not exist in the database file, it is created.
Note: See Electrical standards database file for table naming rules.