1. Create excel file
2. Open control panel, administrative then Data Source ODBC
3. Open System DSN and click add button
4. Choose Microsoft Excel Driver then Finish
5. At ODBC Microsoft Excel Setup, give data source name and select workbook.
At this step, we already make ODBC connection to the data source. Now, we want to setup from cognos connection to use the data source.
6. From cognos administration, open configuration tab.
7. At data source connection click new
8. Give a name for data connection.
9. Choose ODBC for type.
10. Input ODBC data source name with the same name from step 5
11. Click test to make sure the connection has already setup.