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.