>>I have a table with about 40 fields and I am wanting to write a program to import a text file into this table. The way I envision doing this is with 40 fgets() into 40 variables and then do an insert into with the 40 variables. Is the best way to accomplish this task?
>
>I don't think so...I did it that way years ago, but now I use a dbf structure with Append From flatfile Type SDF.

More on this...here's the idea I used:

1) Append all lines into a table T1
2) Create T2, with 40 fields or whatever
3) Create AFIELDS(A1,'T2')
4) Go through loop, using Replace (A1,ncounter,1) with T1 value (SKIP each time) for each grouping of 40 or whatever T1 records, 1 to ncounter. Do APPEND BLANK each time for T2.
5) Reformat any non-char fields afterwards. If you do this regularly, create a program to do it...