Excel export

<< Click to Display Table of Contents >>

Navigation:  Data Module > Import & export > Exporting data >

Excel export

Export of Microsoft Excel (*.xls & *.xlsx) files can be either:

Data_External_Export_Excel

Direct - exports data directly to a file using the same table and column names as the database:

Data_External_Export_Excel_Direct2

Mapped - using a data mapping to create a file structure that differs from that of the database:

Data_External_Export_Excel_Mapped2

noteNote

The first row of each sheet will contain column headers.

All other rows will contain data.

When a mapping is used, the template defines the data types.