Chapter 3 : Creating a Project

If you are importing a file, such as an excel file, in which the first row of your spreadsheet contains column headers that you want to use as field descriptors in your lookup file:

8Check the checkbox beside First line = Column Title

To preview the structure and data of the lookup file you are creating from the file being imported:

9Indicate how many lines you want to view by editing the value beside Number of Lines, or use the arrows to increment or decrement the value in the field

10Click on the Preview button

The first few lines of the imported file are displayed as shown below

Number of Lines is useful if you are importing from a large file and do not need to view all the data to be satisfied that the import fields and data are being properly processed in creating the lookup file.

11Click OK

As shown below, the Lookup File Properties window is displayed again with the fields and field lengths filled in to reflect the data found in the imported file. The fields of your lookup file are from the column headers of the excel spreadsheet. The field lengths are calculated using the data found in the related spreadsheet columns by using the number of characters from the largest data entry found in said column.

October 2007

Page 97

www.mcl-collection.com

Copyright © 2007 • MCL Technologies • All Rights Reserved

 

 

Page 97
Image 97
Datamax v1.1x user manual Check the checkbox beside First line = Column Title, Click OK