Try reading the 'records' of the txt file via fso (add Microsoft Scripting 
Runtime reference to project), then use built in VB Split function to put 
each field of a record into an array element, then addnew or insert 
recordset fields to Access table with the array element values.

EJ