How to use Excel file as input in DataStage??

Showing Answers 1 - 9 of 9 Answers

omkar

  • Apr 23rd, 2006
 

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

aranjan

  • May 9th, 2006
 

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.

  Was this answer useful?  Yes

vikram

  • Jul 18th, 2011
 

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

  Was this answer useful?  Yes

srinu5077

  • Jan 4th, 2012
 

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

  Was this answer useful?  Yes

joel

  • Jun 20th, 2012
 

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)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions