Import of Microsoft Excel (*.xls & *.xlsx) files can be either:
Direct - imported directly from a file that exactly matches the database setup:
Mapped - using a data mapping when the file structure differs from that of the database:
|
•The first row of each sheet must contain column headers. •All other rows are considered to be data. •If a mapping is used, the template used by the mapping determines the data types. |
Note