On Wed, 13 Dec 2000, Adam Lang wrote:
> For curiosity's sake... why are you using getrows?
>
> Much easier to do:
>
> dim fd as ADODB.Recordset
> dim strRow as string
> do while not rs.EOF
> strRow = ""
> for each fd in rs.Fields
> strRow = strRow & " " & fd.value
> next
> debug.Print strRow
> rs.MoveNext
> Loop
> set fd = nothing
Sure, that works, too. All I was trying to illustrate was how he could
establish the connection, which is what he originally asked. Turns out
that's not what he meant, though. What he really wanted to know was how
to create the data source programmatically.
--
Bob Kline
mailto:bkline@rksystems.com
http://www.rksystems.com