Syntax Error in LOAD TABLE

Former Member — Tue, 28 Jan 2020 21:27:23 GMT

I am trying to insert data to a table from a text file. I am using version 16.0 SP11.

This is my sentence:
LOAD INTO TABLE seleccion_materiasit
FROM 'Z:\\Documents\\Libro1.csv'
DELIMITED BY ','
ROW DELIMITED BY '\n' 
QUOTES ON ESCAPES OFF
QUOTE '"'
FORMAT CSV;

And it shows me the following error:
Msg 156, Level 15, State 2:
Server 'escolaresitp', Line 1, Status 0, TranState 1:
Incorrect syntax near the keyword 'INTO'.
Msg 105, Level 15, State 2:
Server 'escolaresitp', Line 6, Status 0, TranState 1:
Unclosed quote before the character string '"'
FORMAT CSV;
'.

I have been testing and searching but I have not found an answer to my problem.

topic Syntax Error in LOAD TABLE in Application Development and Automation Discussions

Syntax Error in LOAD TABLE