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
---------

 

---

Comments

[Tim Copeland]

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

[wow power leveling]

http://www.gamegoldme.com/
http://www.wowgold-powerleveling.com/
http://www.wowgold-wow.com/
http://www.wowpowerleveling.me
http://www.watchrolexshop.com
http://www.wowgold-wow.com/wow-power-leveling
http://rs-runescapegold.com/
http://www.watchrolexshop.com/wow-power-leveling/
http://www.cheap-lotrogold.com/
http://www.globalsale.me/Aion-gold-083.aspx
http://www.cheap-gamegold.org
http://www.gamegoldvip.org
http://www.globalsale.me/