Excel Import File Layout

You can create an Excel file that defines the delimited or fixed file layout for an import. You can base this file on the sample provided in Exchange Manager. Each worksheet name in the file represents a record type. In the example file, the worksheet named HeaderRecord represents a header record type (FileContext). Worksheet A represents an account record (RowContext). Worksheets B through Z represent sub record types. The TrailerRecord worksheet represents a trailer (FileContext).

Note: Worksheet names cannot contain spaces.

Related Topics

Create an Excel Import File

Delete a Record Type

Import an Excel File Layout

Export a File Layout to Excel

Source File Layout