I am trying to export results into an excel file but I can't use union all for header or other unions in the statement. Can you please explain how to do the following stuff you answered in your previous similar message:

"Another solution is to create a preformatted Excel file with headers, fonts, cell formats, formulas, etc... and an "on startup" macro. From a job you can save the exported data into temp XLS of CSV file and then start the preformatted file and have the macro load the data from the temp one."

What was meant there by is that you can have 24x7 export data from db into a tab-separated file and then run an existing Excel file with a simple on-open macro would load that file into Excel spredsheet below the existing headers and with preformated cells, colors, lines borders, etc.... Please try searching the web for how to implement such macro. You should find tons of examples.

: I am trying to export results into an excel file but I can't use union all
: for header or other unions in the statement. Can you please explain how to
: do the following stuff you answered in your previous similar message:
: "Another solution is to create a preformatted Excel file with
: headers, fonts, cell formats, formulas, etc... and an "on
: startup" macro. From a job you can save the exported data into temp
: XLS of CSV file and then start the preformatted file and have the macro
: load the data from the temp one."