Jump to content

Anyone know how to convert OpenOffice DB to MySQL? Any other format?


Recommended Posts

Yesterday my brother came to me with an Open Office Database file. Among everything in the file, he had a few sections that were basically excel looking spread sheet type tables with his inventory in them.

 

I messed with the Open Office program and I can't find a way to export his content into any other file format. I can parse a CSV or the like to get it into MySQL, but I just can't figure out how to get the content into a different file format.

 

Anyone else do this before? suggestions? Alternative programs to OpenOffice that could let me export in other formats?

 

Thanks in advance!

Link to comment
Share on other sites

  • 1 month later...

Try this from the open office help:

Exporting data from Base

You copy a table from Base to a new Calc sheet, then you can save or export the data to any file format that Calc supports.

1. Open the database file that contains the database table to be exported. Click Tables to view the tables, or click Queries to view the queries.

2. Choose File - New - Spreadsheet.

3. In the Base window, right-click the name of the table to export. Choose Copy from the context menu.

4. Click cell A1 in the new Calc window, then choose Edit - Paste.

Now you can save or export the data to many file types.

 

Once it's in the spreadsheet you can save it as csv and import it into mysql.  I fail to see why O.O doesn't have an sql export feature straight from the database interface.

 

Also you should be able to save those forms as html or xhtml. Not sure if the output is very web friendly but give it a shot and let us see what it looks like.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.