Loading data from Excel/Access/Dbf File(s)

Data mapping for Excel file is very similar to the Loading data from a Flat File(s)

  • Click Data Source Option Button.
Toolbar
  • Dialog box will appear.
Datasource Options
  • Select appropriate Data source type.
  • Select appropriate version of Access/Excel if necessary
Datasource Options Excel
  • Click and select the file you would like to load.

    File Selector

  • Select Table to load data from

  • Click OK.

Source Excel File

Note: Specify mask to load data from several files/tables.

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum
Last updated: September 17, 2022