CSV Import breaking on column names with Spaces

It appears that while the CSV import function (into InnoDB) will auto-populate column/field names with spaces (as in the CSV), the import process breaks: 17:13:15 Import started. Wait... 17:13:15 [ Row: 2, File lines: 2-2 ] Error setting value for column 1: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). 17:13:15 [ Row: 3, File lines: 3-3 ] Error setting value for column 1: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). 17:13:15 [ Row: 4, File lines: 4-4 ] Error setting value for column 1: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).

Hi David, If the column names (or the table name) contains spaces, you can check the Use Delimited Identifier checkbook in the Import Wizard. Best Regards, Hans