How can I import multiline text from a Calc table into a Base table without loosing line-breaks ?

[silvain-dupertuis]

I have imported a whole set of Access Database tables into LO Base quite easily, in just 2 steps: 1) copy-paste tables or query into Calc, then 2) copy-past from Calc into Base.

The only problem is with Memo multiline fields in step 2: because line breaks are lost when transferring data from Calc into a Base table. Is there a way to preserve these line breaks?

(Note: I am using LO 5 on Ubuntu. I just used a Virtual Windows XP to open my Access database to transfer data to Calc, but this is irrelevent to my question as everything is correct in this first step. This comment just shows how easy it was to transfer data from Access into Base using Calc as a intermediate step)

[Ratslinger]

I don’t think there is a 100% way of moving table data from Access to Base. What I present is not an answer to the Calc-to-Base problem you have but an alternative method.

I use UCanAccess to connect Base to an Access DB. With this connection, the tables can be copied from the connected Base .odb to the Base file you will ultimately use.

[EasyTrieve]

Access To MySQL will allow you to move to MariaDB / MySQL. Then you can connect to it w/ JDBC.

Keep table names lower case if you can, and note the polarity of boolean true/false goes from -1/0 to 1/0. Also you loose field comments, and of course you loose FK lookups because Base does not support them. I don’t recall all of the issues, but it does move Memo (multiline) to Text ok.