Data Source is an Excel file(s)

Data can be extracted from the entire Sheet or just from the data range. Visual Importer ETL assumes that “Sheet name” and “Range name” are delimited by dot.

Users can still call Sheets as a “Great.Victory”

The logic as follows:

  • Visual Importer ETL checks if Great.Victory sheet exits than it will read it
  • If it does not exists it will check if Great sheet exits
  • If it does exists it will check if Victory range exists if it does It will read data from just Victory range
  • If it does not it will read the data from Sheet “Great”
Please make sure that the range names are not duplicated within the file

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

Confused? Ask question on our ETL Forum

  • vimp/data_sources/excel.txt
  • Last modified: 17/09/2018 10:32
  • by admin