I realise I'm a bit off-topic, as what you are aiming to do here is a semi-manual process. but all the things you do here, and more, can be done via OLE automation. Robyn and I wrote something a while back which will work in SQL Server 2000 as well

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

The advantage in using the metadata from ADODB or odbc is that it will work for any result to give you your column titles, not just a table or view.