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"
)
.Sql = strSQL
.Refresh
End With
I have checked the strConn and strSQL thoroughly.
With Worksheets(1).QueryTables.Add(Connection:=strConn, Destination:=Range("A1"
).Sql = strSQL
.Refresh
End With
I have checked the strConn and strSQL thoroughly.
