Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

In MS office Access for instance there is always a way to import Excel data just right in Access ribben labeled Import External file and by following the wizard view, you can easily link to Excel data.

But I don't know whether it is possible in Libreoffice Base to import Calc data. Is there anyway to achieve that? At work most of the time my colleagues sent me files in xlsx so when I want to use them in base I don't know what to do.

I like base because it can deal with large quantity of data unlike Calc or excel.

share|improve this question

2 Answers 2

up vote 0 down vote accepted

This is possible quite easily. Just set up a database connection to your spreadsheet file:

DB wizard

After clicking Next >>, you will be prompted for the name and path of the spreadsheet file:

DB Wizard 2

share|improve this answer
    
Thank you very much. That was a very fast respond. I tried and it works pretty nice. –  Faska May 25 '12 at 14:28

My problem with the answered above method is that it seems creates a read-only database from the spreadsheet file, so you can't actually edit anything. The same problem occurs with data in text files and system address books. This probably makes the imported data less useful than when it was on the spreadsheet, as then primary keys and stuff can't be added, and the tables can't be edited as the options are greyed out due to it being read-only.

I eventually found a method here that works nicely - here's a summary:

  • Create a new database:

enter image description here

  • Create a table in the database with the same fields/columns/whatever as the spreadsheet being imported

enter image description here

  • Select the data in the spreadsheet to be placed in the database - if you include a first line with labels it can be automatically removed - and copy it. The go to the database, right-click on the entry for the table and select 'Paste':

enter image description here

  • A options thing will then appear, and you can use this to import the data into the spreadsheet. You can also select which fields will be copied by pressing 'Next':

enter image description here enter image description here

That should be another way you can import data into a database.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.