load filed names into an array or counting no of fileds

**parthi_75** · Oct 23rd, 2003, 02:58 AM

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

**mendhak** · Oct 23rd, 2003, 03:26 AM

VB Code:

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

**parthi_75** · Oct 23rd, 2003, 03:33 AM

thanks a lot mendhak, it was very helpful.

**KayJay** · Oct 23rd, 2003, 04:44 AM

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

**mendhak** · Oct 23rd, 2003, 07:48 AM

YW.

**KayJay** · Oct 23rd, 2003, 07:52 AM

**mendhak** · Oct 23rd, 2003, 07:54 AM

Originally posted by KayJay

Whaat? YW = You ******.

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

**KayJay** · Oct 23rd, 2003, 08:01 AM

LOL

Thread: load filed names into an array or counting no of fileds

Thread Tools

Display

load filed names into an array or counting no of fileds

Posting Permissions