Seems pretty straightforward. Can't remember with 100% certainty but i think what you want to do is open the file and loop through each line. For each line execute the Split command, passing as a parameter the semicolon. This should give you an array of 4 strings You can then write a simple loop to iterate over the array and insert the values into the database. On Mon, Jul 26, 2010 at 4:05 PM, Charles Mwangi <mwangicharles@gmail.com>wrote:
Hi VB gurus out there,
Kindly provide code for loading the following test script into an access db using visual basic 6
TT10194C2ASD;6700;254722090909;CharlesMwangi; TT10194C5PST;9034;254722123123;MikeMaingi;
the text has 4 fields separated by semi colons.
The first 3 fields are of fixed length values.
thanks.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke