Hello Xpert,
This has been posted many times ,try using a search use EXCEL as key word.
U can convert the xcel file into csv format and the load the data.
Xpert wrote:Is there any other way, leaving this ODBC and Converting into CSV.
There's always another way. You could, for example, read the XLS file directly and spend a fortune on Microsoft-savvy consultants who can interpret what each byte in the file means. Doesn't mean that the other ways are sensible! What's wrong with ODBC - a Microsoft standard being used to access a Microsoft product?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.