This follows a previous discussion here (that do not have a conclusion ?)
I just created a special one button project to import a .dump.txt file into a .sqlite file.
Everything works fine even if the INSERT INTO syntax appears strange to my eyes:
INSERT INTO "Phone_Book" VALUES('CMS Bourse-Esplanade-Krutenau - 67000','','','','','','15, Rue de Genve','','67000','Strasbourg','03-68-98-51-40','','','','','','',1);
The example in Xojo includes the TABLE Columns names.
BTW: the code uses a TextInputStream, read a line at a time and execute what it is found (FOREIGN KEY, BEGIN TRANSATION, CREATE TABLE with all my Columns and INSERT INTO all my (exported) Records.
For more details on .dump, read:
https://sqlite.org/cli.html#converting_an_entire_database_to_an_ascii_text_file
I generated my .dump.txt file using the Terminal on El Capitan.
I would write Eureka, but, I do not know what to do with that information, so now you know too.
Enjoy (eventually).