i have desinged import application project in vb6.0 and data base connectivity ms-access using, But here first line may be problem importing because first line is information about the data then next numberical are imported properly,so my requirement is importing csv file and datareporting possibly
can you sent me properly coding importing csv below file.
Because the data is in text form and is regular (all records contain the same number of fields and are comma delimited) why not just do a text read followed by a Split to get the fields? The format of the Split command is
It will return an array of strings. Just read the first line outside the processing loop.