hi Steve

See
http://www.rondebruin.nl/accessexcel.htm

See also this page from Ole P. Erlandsen's
http://www.erlandsendata.no/english/...php?t=envbadac



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"steve" wrote in message ...
I was wondering if someone could post a simple bit of VBA that would run a
basic "SELECT" query on a database using ADO and put the values in a
spreadsheet. This would be a great help.