[libreoffice-users] export data from Calc, import to Base

Dear formum,

I believe my objective should be rather simple, but I need to be
pointed in the right direction.

I have a column of text data (unique values) in Calc that I want to
transfer to a Base table. The Base table has been set up with three
columns, two of which I expect to remain empty after the data import.
The one column of unique values will be the primary key.

I thought that the best way to implement the data transfer would be to
create a .csv file from the column of data, but I need help to find out
how Calc supports this. Can anyone help? One idea I had, was to copy
the data column (which contains more than 7000 values, incidentally) to
a text file. Unfortunately, I do not understand enough about regular
expressions to add two commas before each linefeed. Help there would be
appreciated.

(For completeness, the Base Table is a front end to a backend Mysql
database, and I expect the import to be done using phpMyAdmin)

Regards
Harvey


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy