Number of columns in an array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 <--
 
Back
Top