Load MS Excel file in Db2 using RI

Hi,

I have requirement, load MS Excel file (.xls format) in to DB2 using RI cognos data manager. If it is possible how do configure the file .xls file in RI. Please help me from this issue.
Thanks in advance

Hi sasakuma,
I assume you want to read data out of a MS Excel file and load it into the data warehouse. An approach I've taken is to effectively create a table in Excel by using a cell reference over the columns and rows of data to be read. The first row will act like field names which then can be used in the ETL query select clause. You'll also need to setup a connection to the Excel file through ODBC. Which can then be used in Data Manager.
If you want the file loaded as a binary, I have no idea.

ODBC is the only way I've successfully connected to an excel file. If there is another more elegant approach, let me know.
Thanks
DAnny

You can export the worksheet to a CSV file and use the Microsoft ODBC Text Driver. Using the Excel ODBC driver requires that you define a name for the data cells and it also has the drawback of the xls file being locked for some minutes after accessing the worksheet through that driver.

Hi,

I have requirement, load MS Excel file (.xls format) in to DB2 using RI cognos data manager. If it is possible how do configure the file .xls file in RI. Please help me from this issue.
Thanks in advance