Cannot edit imported data in Base

English
, ,
#1

Hello.

I am using Libreoffice Base for my International GCSE ICT exam.
I am practicing with past papers, but I can’t get it to work.
The files provided come as separate csv files, which have to be imported.

I have tried the following:

  • Importing the csv files directly from Base
  • Importing the csv file to Calc, then import the file to Base
  • Create a 2nd database, and copy the tables from the imported DB to the new file.

No matter what I try, I just can’t seem to edit anything. All the editing options are greyed out (even things like cut, paste, etc…)

Can someone please help me?

Is it possible to edit a database created from a CSV file or a spreadsheet?
Live link from Calc to Base
#4

For some unknown reason my previous answer has disappeared. Here it is again.

Depending upon the method used, .csv and .txt files used in Base are read only. There is a method to open .csv file in a read/write fashion. See answer by @PYS - click here.

A similar procedure can be found in the LO documentation in Chapter 2 on page 19 - click here.

#5

So I have to memorize SQL commands? I don’t think I can do that, Internet access is banned during the exam.

#6

It is starting to sound as if your question is incomplete. You only asked about editing a .csv file using Base. What is the process for the actual exam? Why are you using Base? Do you need to return the .csv file with answers?

#7

The exam requires me to add entries to a given database, perform queries, make reports with it, then print it.

#8

If the mentioned method is not acceptable, use the copy/paste method from Calc. I have no problem with this process.

First, create the table with the field definitions. Transfer the .csv data to Calc (make sure field seperators are defined correctly). Select all cells in Calc with the data then right click & copy. On the Base table name, right click & select Paste. On the ensuing dialog box, make sure the correct table name is at the top, Append Data is selected, click “Create” button.

#9

Seems like that’s the only solution that works. Thank you! Should I mark your answer as correct?

#10

You can mark the answer if you accept the answer provided. I can only hope to provide you with something that will work for you.

#2

Ciao, have your tables a ID field set like primary key? Only so they are editable.

If my answer helped you, vote it with :heavy_check_mark:, upper left area of answer

#3

I did do that, but that changed nothing.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.