debasis_mohanty

 Profile Answers by debasis_mohanty Questions by debasis_mohanty

• Oct 17th, 2006

 

Reading data from Excel file is

* Save the file in .csv (comma separated files).

* use a flat file stage in datastage job panel.

* double click on the flat file stage and assign input file to the .csv file (which you stored ).

* import metadate for the file . (once you imported or typed metadata , click view data to check the data values)

 

Then do the rest transformation as needed

-Debasis

 

S

• Oct 30th, 2006

 

• Create a new DSN for the Excel driver and choose the workbook from which u want data
• Select the ODBC stage and access the Excel through that i.e., import the excel sheet using the new DSN created for the Excel