Hi Steve,

See Ole P. Erlandsen at:

Import data from Access to Excel (ADO)
http://www.erlandsendata.no/english/...badacimportado


---
Regards.
Norman


"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.