September 5, 2013 \ Ananth TM \ 2 Comments Read Excel files in Datastage V7.X Need to convert the excel files to csv (save as .csv) then read that file using sequentila file stage. To convert excel into csv ,just do save as csv file and mention delimiter as comma V8.0.1 and onwards There is a way to read Excel files directly. Create a DSN and point it to the Excel file which needs to be read. This is similar to the ODBC connection which will be setup for DBs. Once this is done, you can use ODBC stage in Datastage to connect to this DSN. Each sheet in the excel will be treated as a table and you can write normal SQL query to pull data out of it.