Need to direct the output to an excel template.

cosec · Post by **cosec** » Thu Dec 06, 2007 8:51 pm

I have a datastage Job that gathers statistics from a number of tables and then outputs the result to an excel file.

Currently I am manually copying the results to a specific worksheet(WA2) in an excel file. Another worksheet(WA1) summarizes the results using excel's lookup function.

I am trying to see if I can avoid the part where I have to manually do a copy and paste. Is it possible that I output the results directly to a template ?

If so, please suggest a way to automate it

Thank You.

kcbland · Post by **kcbland** » Thu Dec 06, 2007 8:59 pm

Why not load a table and dynamic link to the table from Excel via ODBC?