[triggerguard]

Hi there,

I'm trying to figure out how to read in a .CSV file into VB so that I can use the data. The field seperator being used is to be a comma. I want the VB to read in the data from the .CSV file row by row as each is a record of an event. I'm not a very experienced programmer so would appreciate any help on this topic. An example of the type of data being used is shown below:

Date Name Age Height
12/04/06 John Doe 36 176
14/04/06 Anne Other 28 159

Cheers

[Advertisements]

Hi triggerguard,
Your problem has two solutions, but I'll take you through the easier one. Firstly, define a Variant variable, let's say data.

Then open your CSV file for input as you would do for any other txt file. Read a line and store it in a string, like OneLine. Then do this:

 data = Split(OneLine,",")

The Split commands takes the string, cuts it ups according to what delimiter you chose (in this case comma) and stores the pieces in the variable as an array. So now data has become an array and contains following:

OneLine contains "12/04/06,John Doe,36,176"

data(0) will contain 12/04/06
data(1) will contain John Doe
data(2) will contain 36 etc.

These are all Variant. You might have to do some re-typing, if you want to.

Repeat the procedure with all other lines

If you have any further problems with my method, just tell me and I'll try to describe it better

[Hai Mac]

Hi triggerguard,
Your problem has two solutions, but I'll take you through the easier one. Firstly, define a Variant variable, let's say data.

Then open your CSV file for input as you would do for any other txt file. Read a line and store it in a string, like OneLine. Then do this:

 data = Split(OneLine,",")

The Split commands takes the string, cuts it ups according to what delimiter you chose (in this case comma) and stores the pieces in the variable as an array. So now data has become an array and contains following:

OneLine contains "12/04/06,John Doe,36,176"

data(0) will contain 12/04/06
data(1) will contain John Doe
data(2) will contain 36 etc.

These are all Variant. You might have to do some re-typing, if you want to.

Repeat the procedure with all other lines

If you have any further problems with my method, just tell me and I'll try to describe it better