Thanks for all the good tips. I have it working.
This last one from Robert works, too. I had tried it before but for
some reason only one record was imported that time. Anyway, good this
time, although patience was needed to import more than 7000 records
(felt like a minute, maybe only half).
Hi Harvey,
mark the content. Copy it to clipboard.
Go to the database file and open the tables pane.
Right mousclick → insert.
Choose the table where to append the data to, choose the column in the
wizard and it will be done.
You won't need a *.csv-file and phpMyAdmin to do this the same
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
On 9/8/22 05:16, Harvey Nimmo wrote:
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,
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