How do I get the name of all columns i access-table?

I access an access-table by this SQL-ADO-string:

SQLGetInfo1 = "SELECT * FROM kalender ORDER BY year DESC, month DESC, day DESC;"
Set rsGetInfo1 = DBConn.Execute(SQLGetInfo1)

Now I want to drop all the names of the columns, that is the field names, into a 1-dimensional array (or perhaps some ordinary strings, doesn't matter), but how do I do that?

I tried with some rsGetInfo1.Fields.Name() and stuff like that, but the bottom line is, I don't really know how to fetch that property.


Hope that someone can help me. Merry X-mas, by the way!

- Madbyggeren
- URL

rs.movefirst
do until rs.eof
response.write rs.Fields.Name & "<br />"
loop

You're obviously not reading what I'm writing. I want to drop them into an ARRAY, first of all. Secondly, I'd like to do it without movenext or loops, since I believe it should be possible just by dumping the field names directly to the array.

- Madbyggeren
- URL

And now I'm obviously not answering.