Ubuntu
openoffice.org package

How export OObase table to comma separated list

Asked by Peter Belmont

I'd like to export a table from a database (open office, Ubuntu) to a comma-separated text file,
line:
  "12", "Name12", $56.45", "True", "12/31/08" CRLF
  "13", "Name13", $56.45", "True", "01/01/09" CRLF

[1] Is this directly possible? How to do it?

[2] Can I write PHP or CC or PASCAL or BASIC code, embed it in a FORM, and use the FORM to dump the table?

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
DrewJensen (atjensen) said : 		#1

If you are using the embedded database then you can just do a SELECT INTO statement and as the target create a TEXT table, attached to a text file.

Go to HSQLdb.org and look at the section in their documentation on TEXT TABLES.

You can use the SQL window or a Statement in Baseic or other scripting language to issue the command.

HTH

Drew

Revision history for this message
Tony Pursell (ajpursell) said : 		#2

Another way is to right click on the table and select Copy. Then open a Calc spreadsheet and Paste. Then do Save As and save the spreadsheet as a Text (csv) file.

Tony

Can you help with this problem?

Provide an answer of your own, or ask Peter Belmont for more information if necessary.

To post a message you must log in.