Delphi 10.3.3 one sheets will excel file data appended to mysql in the same field in the table, tip: Argument out of Range (to the SQL server or access below this kind of success, not only the mysql, do not know how to do)
SSql:=
'INSERT INTO ZQSC +
'(season, the league, round, the game time, event ID, the home team, the visiting team)' +
'SELECT' +
'(season, the league, round, the game time, event ID, the home team, the visiting team)' +
'the FROM [excel 8.0; the database=D: \ Mebet CS9\20170501 auto XLS]. [sc $0304]'.
With ADOQuy2 do
The begin
The Close;
SQL. The Clear;
SQL. Text:=sSql;
Execsql;
end;

CodePudding user response:

Argument out of Range??
You can be first in mysql query tools to test your SQL statements,