Re: Import Excel ods file problem

[Jane Morrell]

Thanks Barry. I'm guessing I have to highlight on the left side the database name which then lists the two tables on the right side.
Then at the top I select the SQL tab and I then entered all the fields I required (see below):

INSERT into race_details(col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, col11, col12,) SELECT (col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, col11, col12,) from Sheet1;

Unfortunatly that gave the error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') SELECT (col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, col11, co' at line 1

My MySQL server version is 5.7.36-39-log