On 1 Jul 2006 00:58:20 -0700, "ladyhawke" wrote:

I fetch the ruslts like this for now:

With ActiveSheet.QueryTables.Add(Connection:=......

With a query that fetches several strings but I can easily make that
just one result. My issue is that I'm just starting out in the VBA
department so I dont know how to open a database connection, store the
result in a string variable and the do the splitting returning the
results to various cells.

The latter part is not a big problem since I've got some ideas from
this question and som on my own :o)

There are more knowledgeable people here that can advise you regarding the
database connection issue. That's not something I've played around with much.

Perhaps if you reposted with a Subject that only mentions the database
connection issue, one of those gurus will take notice.
--ron