Importing Excel files

This feature is available in Import and Validate Pro and Excel Import license versions only.
When Importing Excel files you should not open Excel, or have Excel open, else you will soon be confronted with the Excel Data Link Properties dialog, which will mess things up.


Importing Excel files is done using a combination of

  1. accessing a table in the Excel file by making it a Linked Table (mandatory)
  2. picking up values from individual cells in the excel file using automation (optional).

Ad 1. If you don't have a table from which you need to import records, you can just select 1 cell with a value, and call that the table.

For a complete example, see the in the Tutorials > Import updated prices from Excel

Tutorials on how to work with Import and Validate