i have a data file in text format , i want to convert this text file into mysql database. For this i want coding in vb.net 2003 such that to calculte from this byte to that byte should be update in particular field etc. pls help me? the text file as below
-------------------------------------------------------------------
Timestamp Q Spd Occ Gap Hwy Den Len Cfd #Tot #Cl1 #Cl2 #Cl3 SpdT Spd1 Spd2 Spd3 GapT Gap1 Gap2 Gap3
10/7/2006 0:00:00 18 43 2 208 260 6 27 2 2 2 0 0 38 38 0 0 984 984 0 0
10/7/2006 0:03:00 24 42 3 107 124 10 27 3 2 2 0 0 42 42 0 0 458 458 0 0
10/7/2006 0:06:00 27 41 3 65 84 13 23 3 0 0 0 0 0 0 0 0 0 0 0 0
10/7/2006 0:09:00 28 39 2 222 202 13 20 4 2 2 0 0 37 37 0 0 2216 2216 0 0
10/7/2006 0:12:00 28 41 3 62 70 13 26 2 1 1 0 0 38 38 0 0 187 187 0 0
