Seems pretty straightforward.<div><br></div><div>Can&#39;t remember with 100% certainty but i think what you want to do is open the file and loop through each line.</div><div><br></div><div>For each line execute the Split command, passing as a parameter the semicolon. This should give you an array of 4 strings</div>
<div><br></div><div>You can then write a simple loop to iterate over the array and insert the values into the database.<br><br><div class="gmail_quote">On Mon, Jul 26, 2010 at 4:05 PM, Charles Mwangi <span dir="ltr">&lt;<a href="mailto:mwangicharles@gmail.com">mwangicharles@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi VB gurus out there,<div><br></div><div>Kindly provide code for loading the following test script into an access db using visual basic 6</div>
<div><br></div><div><div>TT10194C2ASD;6700;254722090909;CharlesMwangi;</div><div>

TT10194C5PST;9034;254722123123;MikeMaingi;</div></div><div><br></div><div>the text has 4 fields separated by semi colons.</div><div><br></div><div>The first 3 fields are of fixed length values.</div><div><br></div><div>thanks.</div>


<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>

------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br></div>