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?

Thanks,

Paul