« Migrating to OpenOffice.org ODF Format | Main | Gift Ideas: Gifts for Geeks (Dating Design Patterns) and a Gift Idea Book »

December 04, 2006

TechTarget Article: Getting Data Back Out of OpenOffice.org Base Databases

I've written an article for TechTarget.com on how to export data from a Base database to a spreadsheet or text file.

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

See this blog for how to import data from a spreadsheet into a Base database. (This creates a true Base database, as opposed to a database file that points to a spreadsheet.)

---------
Vote for adding a wizard to import data into Base
http://qa.openoffice.org/issues/show_bug.cgi?id=51904

Utility to export CSV from Base
http://wiki.services.openoffice.org/wiki/CSV_export
---------

 


TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8341cdb1753ef00d83500d46b69e2

Listed below are links to weblogs that reference TechTarget Article: Getting Data Back Out of OpenOffice.org Base Databases:

Comments

Hi,
I'm just a random traveler at your site but I like it very much. I have used OO for several years both at home and at work. Nobody at work knows I use it because I save as doc at work. Does all I need it to which is to write. Have used OO spreadsheets a little but found them a bit buggy in the past, especially when printing. My appearance here is caused by a desire to use Base (OO 2.0.4) to track my billing in my personal business. I have set up a DB and created a report and several forms, none of which please me.
I want my form to display a single record for entry and to use drop down arrows for some fields and to appear blank for others. Here are the problems I encounter:
My billing has a date field. When I click in the form box, I want nothing to appear, then I want an autocomplete that tries to guess the month and year. Right now, the box comes up with the current days date and I have to erase it.
The start time box: It starts with a time matching the last record which has to be erased.
The remarks box: Blank but I wish it to guess the last record's entry.
I have, as I always do, searched for tutorials but found none that give me the tools to do these things. The closest I came was sheepdogguides.com but it gave me a datasheet view and only gave me the means to make a list box.
Is there a book you can suggest, if not an online resource? Thank you.
tim

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment