Microsoft Excel File

The Microsoft Excel File Destination writes data to a Microsoft Excel File.

Excel File

Specifies the path to the excel file where data should be written to.

Choose a previously used Excel File

Click on the connection Drop Down to choose a excel file previously used.

Choose Excel File

Click this button to choose an excel file.

Excel Template File

Specifies the path to an excel template file.

Normally DbTransfer creates a new (empty) excel file to put the data in.

When you specify a template file, then this template is used instead of an empty excel file.

The template file can be an ordinary excel file or an excel template file.

Data Types

DbTransfer can read data from an excel file in two ways: Using native excel data types or using only texts.

Native Excel data types

DbTransfer will write values as their native excel data types in excel files.

For example decimals are stored as native excel numbers.

This is useful when you want to be able to sort values in the excel file and use values in formulas.

Text

DbTransfer will write all values as text in excel file.

For example decimals are stored as their textual representation (according to the settings specified in the Data Format section) and not as native excel numbers.

When you are using excel files as backup for your database this is the recommended mode, since it will prevent excel from changing (reformatting) values.