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

Recommended Answers

All 2 Replies

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.