Excel sample with ADO / SQL
 

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.

Excel sample with ADO / SQL
 

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.

Excel sample with ADO / SQL
 

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.