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

Hi Harvey,

my answer is older and I have not checked, whether the methods still 
work, but perhaps you try it?
https://listarchives.libreoffice.org/global/users/2011/msg02407.html

Kind regards
Regina

Harvey Nimmo schrieb am 08.08.2022 um 21:16:
> 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