"Frank_Hamersley" wrote ...

Am going to go down this path after a fashion. The minor complications are
that multiple result sets can get dumped on to a single sheet hence the
optimal choice for the format may change as several points down the page. I
know the extent (in rows) so I will be doing bulkier updates that now.

The other fly in the ointment is that the tool can be wired to read text
files as well as ODBC data sources and so I still need to do best guess
formatting on the data - mainly to improve readability, but also to ensure
date arithmetic, column totalling etc actions work as the user would expect.

Something else to consider would be to query (a closed copy of) your
Excel results i.e. get Jet to determine the majority data type. More
details on Dick Kusleika's site:

http://www.dicks-blog.com/excel/2004...al_data_m.html

Jamie.

--