poppy wrote ...

I want to be able to find the last empty row in a worksheet and work
out the totals of each column and place it in this row.

As you used SQL to fetch the data, I can tell you can use a query to
insert the total in Excel e.g.

INSERT INTO
[MySheet$B3:B65536]
(Price)
SELECT
SUM(Price) AS Price
FROM
[MySheet$B3:B65536]
;

Although in the above the maximum rows has been specified, in reality
the provider will find the next unused row and insert the total there.
However, a SQL insert can only be done on a closed workbook. Is this a
show-stopper for you?

For your original question about formatting, your sample data is all
over the place as I see it:

http://groups.google.com/groups?selm...rum-nospam.com

You may want to repost.

Jamie.

--