https://bugs.documentfoundation.org/show_bug.cgi?id=135616
--- Comment #2 from [email protected] --- (In reply to JustAsking from comment #0) > Description: > I'm trying to load data into a Firebird embedded DB using an external table > using the SQL statements explained here: > > http://www.firebirdfaq.org/faq209/ > > CREATE TABLE ext1 EXTERNAL 'c:\myfile.txt' ( field1 char(20), field2 > smallint ); > > The issue is that I can't find 'firebird.conf' in the embedded server > distributed with LO. 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. In the future that could even be automated by the UI. > Indeed there is no firebird.conf file in the default installation, but you can create one. The easiest way to create it is to download a zip installation of firebird 3 from the firebirdsql.org download page and extract the firebird.conf file with all the options. You can also create a plain text file, name it firebird.conf and put in it only the settings you want to change, for example ```ExternalFileAccess = Full```. Keep in mind that you also have to deal with OS access permissions to the external file location. That location has to allow the *firebird* user to access and create files in it. -- You are receiving this mail because: You are the assignee for the bug.
