Number of columns in an array

M

Markm-s

How do I find out the number of fields an array has? I'm importing from a CSV
file and some times there is a different number of columns. Using a Split on
the text line with ","

Thanks
 
S

Stefan Hoffmann

hi Mark,

Markm-s said:
How do I find out the number of fields an array has? I'm importing from a CSV
file and some times there is a different number of columns. Using a Split on
the text line with ","
Click to expand...
You can use LBound(array()) and UBound(array()) to determine the lower
and upper bound of an array.

btw, why don't you use DoCmd.TransferText to import your file?


mfG
--> stefan <--
 
Top