lnfile=Fopen([C:\Spillman\FoxData\]+lcTable+[.txt]) If lnfile < 0 Messagebox("Error opening file!") Else Do While Not Feof(lnfile) lcLine = Fgets(lnfile,700) lnOccur= Occurs('|',lcLine) lnPipe1 = At('|', lcLine , 1) lnPipe2 = At('|', lcLine , 2) lnPipe3 = At('|', lcLine , 3) lnPipe4 = At('|', lcLine , 4) lnPipe5 = At('|', lcLine , 5) lnPipe6 = At('|', lcLine , 6) lnPipe7 = At('|', lcLine , 7) lnPipe8 = At('|', lcLine , 8) lnPipe9 = At('|', lcLine , 9) lnPipe10 = At('|', lcLine , 10) lnPipe11 = At('|', lcLine , 11) lnPipe12 = At('|', lcLine , 12) lnPipe13 = At('|', lcLine , 13) lnPipe14 = At('|', lcLine , 14) lnPipe15 = At('|', lcLine , 15) *insert or append to your table here endif