ODI Excel question

ismaill

Hi,

i have table in odi.and i want to to transfer the data in the table to a excel file using odi.
how can i do this??

566902

You are better off using the "IKM SQL to File Append" and to export the data to a csv file. If you really want to put it in an xls file, then you'll have to define a data server using the Excel technology, and use the JDBC ODBC bridge to write to the excel file.
You alos have the option of using the OdiSQLUnload tool to write to a Type=variable file.