Ask Your Question

Syndax error on base with LOAD DATA

asked 2015-01-24 21:40:51 +0200

alain.fontaine.566 gravatar image

I enter the following request LOAD DATA INFILE 'v:/work/dev/tdl/data.sql' INTO TABLE TBL_TACHES FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n': Table exists file exists and is compliant then I got a SQL syntax error w/o any information LibreOfice 4.3 Thanks

edit retag flag offensive close merge delete


Spelled: Syntax

EasyTrieve gravatar imageEasyTrieve ( 2016-11-07 18:07:16 +0200 )edit

Without any further information as to which database you have exported from and which database to are attempting to load data into, it is unsurprising that no one has come forward with a suggestion. For these kinds of operations, it is usually better to attempt them from a terminal or an interface that specifically allows for DDL/DML operations. The Query UI in LibreOffice does not allow this, only SELECT requests are allowed. The Tools > Options > SQL allows most (but not always all) DML/DDL statements, and errors are sometimes not always reported in the most useful way.

Alex Thurgood gravatar imageAlex Thurgood ( 2019-02-22 11:52:23 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-07-20 04:49:04 +0200

lazarus477 gravatar image

Perhaps an alternative solution would be to setup the schema manually in Base and import the external data from CSV files. Just a thought.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-01-24 21:40:51 +0200

Seen: 144 times

Last updated: Jul 20 '19