Ask Your Question

How may I edit an imported database from a TXT file ? [closed]

asked 2013-12-17 01:06:41 +0100

mrmister gravatar image

updated 2013-12-17 01:07:47 +0100


I have a folder with a TXT file, and I have in that TXT file all the necessary information to create a database... all separated by commas... so I can import it perfectly in LibreOffice base, and I see it as a table with the fields and everthing fine... but... I don't have a primary key, and also I cannot edit the current entries and add new ones... so how may I add new entries and edit the current ones? The read TXT file and converted into a table, seems to be a read-only table, and I want to deal with it, entering new information or editing the current one... I really don't know how to do this? Any clues or ideas to do this?


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-16 17:02:18.221941

1 Answer

Sort by » oldest newest most voted

answered 2013-12-17 05:11:34 +0100

frofa gravatar image

You need to add a PRIMARY KEY to your table. There are different ways to do this - see HERE. MTP's suggestion (last posting) to copy your table and add the PK during that process might be the simplest.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-12-17 01:06:41 +0100

Seen: 138 times

Last updated: Dec 17 '13