BlkAttPop Attribute Value Populate

Populate existing insert attributes with lookup values from Excel spreadsheet or Access database. Take existing inserts with a single attribute that can be looked up in the database, and automatically fill in other attributes based on attribute tag to field name relations.

Keyboard Command: BlkAttPop

BlkAttPop

Procedure:

  1. Choose the Select Inserts < button and select the inserts you wish to process.
  2. Choose the Select button and choose your MDB or XLS file.
  3. Choose the Retrieve button and then select the Table/Sheet to use.
  4. Choose the Lookup Field to use. This is the attribute in the blocks that contains a value that will correspond to a lookup field in the database.
  5. Choose the OK button to begin populating the inserts.

Note: The tag names from the block definition and the field names from the database must match exactly.