On Mon, 2013-11-11 at 00:03 -0800, John Andersen wrote:
lynn
wrote:
OK. I worked it out: In base opening screen:
What do you want to do? Create new database > Next > Yes, register the database for me > Open the database for editing > Finish
open the csv > edit > select all > edit > copy back to base: click Tables > edit > paste (give it a name)
choose all the fields > Next > Create > add a key if you don't have one
You can now edit everything:) L x
Ah, very cool. I never tried the paste option, because the csv was huge.
No matter what the size of the csv, you are pasting into 'nothing'. There is nothing yet on screen to suggest it. It was a student of mine who found it by accident. I only realised what had happened because he had a working import wheras everyone else had read only. I asked him to retrace his steps. Certainly not intuitive. Apart from that, it's just as easy as Access; you can drag and drop whole fields and records from txt and calc files.
If it was that easy, why haven't the LO guys made that an option after you connect to a csv, to save the content and disconnect from the csv. If they can read it in, they should be able to simulate a copy-paste.
There's something similar here: https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base Which introduces the read write confusion you mentioned. HTH L x -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org