Template Wizard - Step 3 of 5

In this step, you identify each cell you want to copy data from and the corresponding database field you want the data copied to. The data from each workbook based on the template creates one new record in the database.

Sheet or Table

Enter the name of the sheet or table in the database where you want the data copied. If you're creating a new database, you can type a new sheet or table name. If you're using an existing database that has multiple sheets or tables, click the item you want.

No.

Identifies the database fields, numbered from left to right, to which data from the selected cells will be copied.

Cell

Specify each cell that will contain data you want copied to the database. To enter a cell reference, first click in the Cell box, and then click the cell on the worksheet, or if the dialog box covers the cell you want, click the Collapse Dialog button in the box and then click the cell. The wizard creates an absolute reference to a single cell; you cannot use relative references or range references.

You can enter cell references from multiple worksheets; however, you must include the sheet name — for example, 'Sheet 1'!$B$3 — if your template contains more than one worksheet.

Field Name

The name of the database field to link to the cell.

New database   If the selected cell is below or to the right of a text label, click in the Field Name box to enter the label as the field name, or type another name. The field name must meet the requirements for field names in the selected database.

Existing database   The field names from the database appear automatically — you cannot change the names.