Re: Problem with APPEND FROM <Filename> TYPE DELIMITED

What's the structure of your DBF, notably the definition of the 58th field?

On Mon, Nov 23, 2020 at 9:14 PM Paul Newton Paul.Newton@pegasus.co.uk wrote:

I have a CSV file (MyFile.CSV) with a single line that looks like this: FIN005,,06/11/2020,06/11/2020,06/11/2020,T116434,C,,,,,,,N,,,,,,,8300,,-15,,-3,,,H,S,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,LEITH You can verify for yourselves that LEITH is the 58th column. I have a table (MyTable.DBF) with 66 fields and Field(58) returns SA_JOB

The following fails to populate SA_JOB

Select MyTable APPEND FROM MyFile.CSV TYPE DELIMITED

All the other columns are correct in the table. I am completely stumped so any help would be much appreciated.