I’m trying to load data into a Firebird embedded DB using an external table using the SQL queries explained here:
CREATE TABLE ext1 EXTERNAL ‘c:\myfile.txt’
After that I’m trying to populate a normal table with the external data using
INSERT INTO realtable1 (field1, field2)
SELECT field1, field2 FROM ext1;
The problem is the data from the external table is not visible in Base and the second statement returns:
1: firebird_sdbc error: *Use of external file at location C:\Program Files\LibreOffice\Cndtn_Code.txt is not allowed by server configuration
I guess this is a problem with the parameter ‘ExternalFileAccess’ that must be set as either ‘Restricted’ or ‘Full’ in the ‘firebird.conf’ file to allow the access.
The only problem is I can’t find firebird.conf in the embedded server distributed with LO. Does someone know how to solve this? The SQL Statements can be done in macros and I find that way more convenient than the usual copy&paste method to insert existing tables in Base.