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.