The Excel file is treated as a table when it is being read through the ODBC Data Source Name (DSN). The ODBC DSN does not recognize the data in the Excel file by default. A name has to be defined using the Define Name functionality in the Excel file so that the name would be treated as a table name using the ODBC drivers.
To import an Excel file in the PowerCenter Designer, do the following:
What can we do to improve this information (2000 or fewer characters)