Re: Import Excel ods file problem

[Jane Morrell]

I tried:
INSERT INTO race_details TABLE Sheet1;
But in the SQL page on the left side there is a red X which reads 'Unexpected keyword (near TABLE)'
However, I did try it and this is the Error:
Error
Static analysis:
2 errors were found during analysis.
Unexpected keyword. (near "TABLE" at position 25)
Unrecognized statement type. (near "TABLE" at position 25)
SQL query: Copy
INSERT INTO race_details TABLE Sheet1;
MySQL said: Documentation
#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 'TABLE Sheet1' at line 1


I then tried without the '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;

"Bingo, it worked"

I do thank both Peter and Barry helping this I wont say Novice, as a more apt description would be 'Know nothing very elderly lady'.