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
Spelled: Syntax
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.
Perhaps an alternative solution would be to setup the schema manually in Base and import the external data from CSV files. Just a thought.