How to Import Data From Spreadsheet into OpenOffice.org Database

There are certain times when we have data in a spreadsheet and we want to get it into our database. So how to go about it. I’ve thus designed a small tutorial for the same.

Here we go:

1. First open you spreadsheet of table in OpenOffice.org Calc and give name to the columns in the table.

Then copy the data as shown in figure

2.  After that,  open the OpenOffice.org Database file and click on tables button as shown in figure and right click on the show area as below

3.  You can see paste option enabled. Just paste it there and then follow the import options

Give a name to the table, select what you want to import ( data or the format of the table)

4.    Then select which columns of the tables you want to import

5. Format your fields and set your primary key.

6.   Thats it.. We are done…

7.   There is the table

In this way a lot of painstaking is reduced and the work is more efficient

You can also check out another post on exporting the data

CHEERS!!!