Importing Multiline Data From Word-Processing File to Base

[BruceTheShark]

I have a number of legacy databases that were created via word processor. Each record is a page (with a hard newpage), and there are fields within it with variable numbers of lines — and the lines must be preserved. (Illustration, although not these database: A recipe in which the ingredient list is a single field with multiple lines, and an unpredictable number of those lines.)

I’ve tried following the various “convert it to DBF” methods, but:

1. They don’t handle multiline fields within a single record. I tried a kludgy conversion in Calc using the substitute() function (converting a placeholder to char(10)) into another table, which at least worked within Calc, but conversion to a DBF won’t operate on just one table within a worksheet, and anyway:
2. There doesn’t appear to be a way to import the data – only create a link to a DBF. That’s not acceptable: This needs to end up as a single database with no outside dependencies (so one can copy just the odb to another computer).

[Wanderer]

Attention .dbf means dBase, this is not what you want
.

1. use html <br> instead of chr(10) in Calc. Afterwards you can copy a table to a Database-Table in Base
   .
2. You require an “embedded database”
   Create the database in Base first, then copy the tables from Calc.
   .
   Another hint: Base is not a database. It connects to data-sources of your choice. You can choose HSQLDB and Firebase as embedded databases.