Hiya Chris ---

Are there any Memo fields in the target table? This would cause a problem. Usually, unless it's a real simple import, I use FOPEN() and do a line by line read of the source file and manually parse the data. Why? Because you can validate the data before committing to saving the information.

>
>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