There has been many tutorials about how to import data into openoffice.org calc from various formats. But i find there is some thing missing.
How to import data from and excel sheet or any spreadsheet into “openoffice.org base” application?
Well normally there is no menu path like in ms acess to import a table from excel sheet. I have search all menus in the base but i was unable to find how to do that.
Coming to how to do that
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
After that open the openoffice.org base file and click on tables button as shown in figure and right click on the show area as below.
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)
Then select which columns of the tables you want to import
format your fields and set primary key
you are done with importing finally…..