Error importing csv file into table.

[OnMyBike]

I am importing csv files into tables in a batch routine and I get the following error messages. The error number is always 2391.

Field 'F1' Doesn't Exist in Destination Table
Field 'F4' Doesn't Exist in Destination Table
Field 'F36' Doesn't Exist in Destination Table

I understand the first one and can find references to this on the web but the F4 and F36 escape me.

All fields required do actually exist in the table so the real problem is
elsewhere.

Any ideas anybody?

Thanks

P.S. I now think that it may be that there are embedded commas in one or more of the text fields and that the number following the 'F' indicates the position of the field in the table. I will check in the morning or create the csv files using commas and quotes.

 

[GinaWhipp]

If you still have an issue after *fixing* the embedded commas issue then it might be you have to use Automation to import your file. We'll be standing by to hear back...