Ubuntu
openoffice.org package

Importing or linking spreadsheets in Base

Asked by Peter Freeman

I am moving over from MS Access to Open Office.Org Base and I wanted to know if there is the ability to either import a spreadsheet so that it ends up as a table, or to link to a spreadsheet so it appears and functions as a table. MS Access has this capability.

Thanks,

Peter

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Peter Freeman
Solved:
Last query:
Last reply:
Revision history for this message
Vivien Taillandier (vivien) said : 		#1

OpenOffice.org Base got both functions.
However there is a limitation in the second one, because you can't create links in your table, or to be more honest, I couldn't do it.

Since I hardly used MS Access, I don't know if a primary key is generated by default when you import a spreadsheet (by copy / paste), but you have to do it manually in Base. You also must take care of the label strings (must be ASCII).

Hope it helped.

Vivien.

PS : I'v just started answering these kinds of ticket. So please, don't hesitate to tell me what you think about it. Thanks !

Revision history for this message
williamts99 (williamts99) said : 		#2

http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html

Explains exactly how to import your spreadsheets.

Revision history for this message
Best Peter Freeman (pfreeman-mcomi) said : 		#3

Hi Vivien,

Thank you for your quick response. Using the information you provided plus a response from williamts99 I was able to import my spreadsheets into Base.

I liked your response and I hope I will be able to provide you with guidance in the future. I'm an MS Access, Excel and Word guru, however I am trying to understand Open Office's approach.

Cheers,

Peter