[Skunkworks] VB GURUS - LOAD TEXT FILE INTO ACCESS DB

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.