Ask Your Question

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

asked 2017-03-29 13:47:53 +0100

silvain gravatar image

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)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-03-30 06:16:17 +0100

EasyTrieve gravatar image

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.

edit flag offensive delete link more

answered 2017-03-29 15:34:25 +0100

Ratslinger gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-29 13:47:53 +0100

Seen: 90 times

Last updated: Mar 30 '17