Excel sample with ADO / SQL

S

steve

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UPDATE through a QueryTable? Or? 0
ADO question 15
import Excel worksheet to SQL Server table 7
Autonumber field in Excel that behaves the same as Access 0
MDX Statement to an SQL Server Analysis Services with ADO 0
Can you use ADO from Excel to run an Append Query in Access 2
ADO connection to a protected workbook? 3
Using Excel to search Word documents? 2

Top