Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Syntax Error in LOAD TABLE

Former Member

‎2020 Jan 28 9:27 PM

0 Likes
470
  • SAP Managed Tags
  • SQL
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.
0 REPLIES 0