Hi all,

In one of my applications, we need to import a fixed width flat text file with lines that are longer than the 254 characters. The import wizard will allow me to import the data into each field, but I can't seem to duplicate this using the append command for data in the file that occurs after position 254.

Eg

Data from position 1-100 goes into field 1 in my table
Data from position 101-200 goes into field 2
Data from position 201-254 goes into field 3
Data from position 254-320 goes nowhere but it needs to go into field 4...

It's really frustrating - but there must be a solution somewhere (I hope)....

Regards

Chris Kable
MotorLink Systems