Hi,

If you record a macro whilst using Data, get external
data, new database query, you'll get a (bit garbled) idea
of the connect string. It will probably be recorded into
some sort of ARRAY function, but you can easily join all
parts together into one single string and use that.

Regards,

Jan Karel Pieterse
Excel TA/MVP

-----Original Message-----
Hi,

I am writing a macro which uses ADO to connect to the
AS400 database. What is the connection string?
On the other hand, I would like to put the result by a
QueryTable, what is the syntax?

Thanks.

Terence

.