How to use Excel file as input in DataStage??

store input excel file as .csv file and use sequencial file stage to read that file..!!!

You can use excel file as input by importing the .xls file.

Step1 --> Go to Administrative Tools -> Data Source (ODBC) --> System DSN. Click on Add button and configure the corresponding .xsl file in your system DSN. Make sure that workbook contains the name of your excel sheet.

Step2 --> Import the excel file into the datastage as ODBC table definition.

Step3 --> Use ODBC stage as input stage.

You should be able to use excel file very effectively. Please let me know if you face any problem.

I did follow the step1, when I try to import excel file into datastage as ODBC table definition, when I select DSN name and OK then it says NO MATCHES FOUND. plz help me.

Vikram

I did same as step1, but when i import the metadata it asking username and password, when press ok button it shows NO MATCHES FOUND, pls help me

Thank you
Regards
Srinivas

The above answer is wrong.

Please follow the steps below to load the excel in dataastage :-
first open excel sheet and open->saveas-> then save the file as .csv extension
while importing u have to select .csv instead of txt
second take the sequential file stage and read the .csv file (just give the file path with file name)