Hi,I have read through posts on reading excel files.
Just wanted to know if in Datastage 8.7 is this facilty available or still we have to read from .csv itself?
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-05-02T21:12:55Z by evangeld
Pinned topic Read .xls or .xlsx file in Datastage 8.7
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-05-02T21:12:55Z at 2012-05-02T21:12:55Z by evangeld
evangeld 2700022W0K1 PostACCEPTED ANSWER
Re: Read .xls or .xlsx file in Datastage 8.72012-05-02T21:12:55Z in response to ChetancWe have been able to read .xls files with the Microsoft V6 ODBC drivers. When we upgraded to the V14 drivers (which support .xlsx) we get an error "System resources exceeded". We are working with support to find a resolution.