0

Dear sir,
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.

1, 00051873, 04/21/2013, 11:11:25, 04/21/2013, 181,Supplier No. 1, خلاص, 00249157, 307, NA, 25
37.5,21.4,3103,1.75,38.1,41.1
38.8,23.6,3780,1.64,44.4,54.0
39.7,24.1,3893,1.64,40.6,47.1
34.4,21.8,3151,1.55,39.4,44.5
37.0,30.3,4351,1.21,42.2,48.0
37.9,22.3,3387,1.69,44.7,51.4
31.2,23.2,2878,1.35,37.5,42.3
29.0,22.3,2637,1.29,42.7,49.7
31.7,18.3,2361,1.70,44.2,50.9
41.9,25.0,3965,1.67,45.4,54.0
33.0,26.8,3254,1.23,44.0,51.9
37.5,22.7,3486,1.62,39.8,43.8
32.1,20.5,2772,1.53,51.7,59.6
31.2,26.8,3304,1.16,35.9,38.9
37.5,33.0,3713,1.13,47.1,52.9
29.9,24.5,2825,1.21,41.2,46.2
37.0,20.5,2742,1.79,41.0,46.9
31.7,24.1,2829,1.29,46.9,56.9
35.2,23.2,3356,1.50,42.2,49.2
31.7,21.4,2599,1.47,43.3,47.4
31.7,20.5,2741,1.51,50.8,58.8
30.8,23.2,2883,1.32,42.0,46.8
37.5,26.3,3586,1.43,45.5,52.8
34.4,22.3,3106,1.53,42.1,48.0
33.5,21.8,3039,1.52,47.8,54.3

3
Contributors
2
Replies
13
Views
3 Years
Discussion Span
Last Post by GeekPlease
0

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

Split(line,",")

It will return an array of strings. Just read the first line outside the processing loop.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.