Hi,

I am trying to use the following in an excel (2003) spread sheet:

With Selection.QueryTable
..Connection= "ODBC;DSN=Live;UID=admin;;SERVER=LIVE;DBNAME=DATA; LUID=admin;"
.CommandText = strSelectStatement
.Refresh BackgroundQuery:=False
End With

and I keep getting :

Error Number: 1004
Error Description: Application-defined or object-defined error

I have had a quick look at the help files and online and have tried a number
of alternatives but with no success.

Any help/tips greatly appreciated.

Thanks,
J