1,105,344 Community Members

import csv file in vb6.0 with ms-access

Member Avatar
mirzabaig
Newbie Poster
1 post since Jun 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
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

Member Avatar
Reverend Jim
Noli mentula
5,444 posts since Aug 2010
Reputation Points: 746 [?]
Q&As Helped to Solve: 653 [?]
Skill Endorsements: 51 [?]
Moderator
Featured
 
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.

Member Avatar
GeekPlease
Junior Poster
109 posts since May 2013
Reputation Points: 16 [?]
Q&As Helped to Solve: 8 [?]
Skill Endorsements: 0 [?]
 
0
 

Perhaps, you can read this

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