Filter
Top Products
Copyright © 2007 • MCL Technologies • All Rights Reserved
www.mcl-collection.com
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:
8 Check 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:
9 Indicate 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
10 Click 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.
11 Click 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