[FAQ000084]When importing table data, the message "Specified file is not compatible with the field. Please check the file." appears¶
Q¶
When importing CSV files of table data,
the message "Specified file is not compatible with the field. Please check the file." appears.
What is the problem?
A¶
Please check the following possible causes.
・Header is not assigned to the first line of CSV
The CSV file created by exporting the table to be imported has a header,
so copy this header and insert it into the first line of the CSV file to be imported.
・The number and names of header columns do not match the columns in the table to be imported
Column names must match both single-byte and double-byte names.
Also, the table columns "ID", "LAST_UPDATER", and "LAST_MODIFIED" can be omitted from the CSV file.
Please see here for details.
Related keywords¶
Import, database, DB