load filed names into an array or counting no of fileds

dear all
how to know how many number of fileds are there in a table and i need all the field names loaded into an array. replies and help will be appreciated.
thanks
periyur

VB Code:

msgbox objrs.Fields.Count
'Number of fields
 
For j = 0 To objrs.Fields.Count - 1
strArr(j) = objrs.Fields(j).Name
Next

thanks a lot mendhak, it was very helpful.

Also take a look at the GETROWS method. Of course it retrieves the data as well.

:)

YW. :afrog:

:confused:

Quote:

---

Originally posted by KayJay
:confused:

---

Whaat? YW = You ******. :D

Or You're Welcome, depends upon whether the glass is half full or half empty. :)

LOL :D