How about a SQL UNION ALL followed by a COPY TO xlfile.xls TYPE XL5?
This is limited to 16,383 rows but if you have less than that - no problem.

>Hi all:
>
>I am looking for a way to take data from multiple tables and put them into 1 Excel worksheet and totaling each table
>
>Peter