Hi

I am writing a code in VB 6.0. i want to Read the .csv file and insert into the SQL Data base. i wrote a code in VB that will read the data in Row wise. but i want i want to read it by Column wise

here is my .csv file data, here first row(only for 1st row) first colum value is empty. this "|" is column seperater

|780|880 | 990| 875| 960|
1000|0 |200 | 600|0 | 200
5000|200|800 | 400|0 | 100
900 |765|200 | 600|0 | 200

i want to insert this data into sql in this format.

cst_cnt_code| Accout_NO| Budget
780 | 1000 |0
780 | 5000 |200
780 | 900 |765
880 | 1000 |200
880 | 5000 |800
880 | 900 |200
990 | 1000 |600
990 | 5000 |400
990 | 900 |600

i want to read the .csv file in the about format. how do i do that.

Thanks in advance

Thanks & Regards
Gandhi