I am having a problem importing or appending a fixed width text file into a table. The data I want to put into fields is not delimited but is separated by various numbers of spaces. The Import Wizard does what I want but I am trying to achieve the same in a stand-alone application. I have tried putting the text file into a temporary table and using substr() to parse the fields into another table but it takes quite a bit of time. Any help would be appreciated.

example:
Text file: 123456789 12345 123456

Table: Field1 Field2 Field3 Field4 Field5 Field6
123456789 12345 123456