How to Navigate This SmartConnect Error: ‘Cannot find table 0 when using Excel File as a Source’

In this video, you will learn how to navigate this SmartConnect error: ‘Cannot find table 0 when using Excel File as a Source’. We will explain the real cause: the sheet name in the Excel file doesn't match what the map expects.

You'll learn how to:

  • Fix it by simply renaming the sheet (faster than recreating the file)
  • Use the "Select File at Runtime" option to avoid mismatches (for manual runs)
  • Prevent this error by correcting upstream processes or human error

This is a must-watch for SmartConnect users working with Excel File sources who want to avoid unnecessary manual steps and ensure reliable map execution. If you'd like to read the help article that goes with this, click here.