On Sun, 2013-11-10 at 17:05 -0800, John Andersen wrote:
On 11/10/2013 4:54 PM, lynn wrote:
I couldn't find anything that did an import of a CSV to a DB.
You create a new db and select text > csv and the source.
Try again, please, that instruction was perfectly opaque.
I saw an option to attach to an existing database, and offered the option of attaching to a spreadsheet, but that option clearly said it would open it READ ONLY.
Yeah, it opens the csv read only. That's what we want. You can edit the resultant spreadsheet though.
I can't. The DBs I created from the Attach to spread sheet is locked and can't be edited, not for structure or for content.
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 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org