Re: Import Excel ods file problem

[Barry Galbraith]

It looks like I should have checked the refman instead of relying on memory.
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html

There is no parenthesis around the SELECT list.

INSERT into race_details(id, name, loft_number, race_code, ring_number, miles, yards, hours, minutes, seconds, clocked, time_field) SELECT A, B, C, D, E, F, G, H, I, J, K, L from Sheet1;

The refman even has a shortcut if your MySQL = 8.0.19 or greater.

INSERT INTO race_details TABLE Sheet1;

Good luck,
Barry.