1.11M Members

import csv file in vb6.0 with ms-access

 
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

 
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.

 
0
 

Perhaps, you can read this

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article