General ODBC Error

[dionu]

I am trying to add a querytable to an Excel form and I am receiving a general ODBC error at the .Refresh line of the following code... any ideas?

With Worksheets(1).QueryTables.Add(Connection:=strConn, Destination:=Range("A1&quot)
.Sql = strSQL
.Refresh
End With

I have checked the strConn and strSQL thoroughly.

 

[euskadi]

Dionu,

I'm not one for doing those sorts of tasks by writing straight VBA... what you might try is to record a macro doing the action you would like Excel to replicate, and then clean up the result a bit and add in your variables for the connection and the SQL. Excel will probably add a lot of extraneous lines that you can judiciously remove, but you're sure to get the code right.

Good luck!