VBA does not seem to like the line continuation _. If I put my query on one
line 600 spaces long it works, but the query is hard to read that way.



"Dick Kusleika" wrote in message
...
On Tue, 3 Mar 2009 07:08:25 -0700, "Striker"
wrote:

I'm trying to query a SQL database and bring the results to a spreadsheet.
Be gentle on my, I have not coded in VBA for many years.

I'm thinking I can open a connection lke this
Set MyConnection = new ADODB.connectio0n
MyConnection.Open "Driver=SQL
Server;Server=MyServerName;Database=MyDatabase ; (not sure I need a
password)

So question is how do I run a SQL query? I have only used this to add
stuff
to a database before?


Dim rs As ADODB.Recordset
Dim sSQL As String

sSQL = "SELECT * FROM MyTable WHERE ID=1"

Set rs = MyConnection.Execute(sSQL)

More info here
http://www.dailydoseofexcel.com/arch...set-basics/%5C
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com