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?
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 Post
Re: Read .xls or .xlsx file in Datastage 8.72012-05-02T21:12:55ZThis is the accepted answer. This is the accepted answer.We 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.