« OpenOffice Template for Writer: Suppressing the Page Number on the First Page | Main | Creating Keyboard Shortcuts in OpenOffice, including Assigning Keyboard Shortcuts to Styles, a GREAT Feature »

April 06, 2007


When I try this my column headers all end up in alphabetical order but the columns stay in the same place, effectively screwing up the spreadsheet.


This system works well with smaller tables, but when trying to get a nasty imported mdb into a spreadsheet to then export into mysql, it seems to have frozen completely. There are 18 thousand records, so its probably best to use with discretion.

this has been fantastically useful.

One other question: is there a way to get a query result data out of open office base, either through making a table from a query or otherwise?

Hi Iain,

It should work; just click the Queries icon at the left side of the window, then copy the query you want instead of a table.


HAH! This is to simple and elegant - I love Open Office!

I agree with keet...this method is totally broken for large tables or queries...my query had ~6000 records, pasting into calc took a long time (I thought it might crash but it made it after about 10 minutes)...but even after it finished, round about record # 4500, the data failed to copy...after that the only record that was pasted correctly was the last one. Weird.
The same thing happened in 2.0 and 2.4.1

The better solution is to register you DB in OO, create a query, then save and close base. Then open a new Calc spreadsheet, and in the view menu click "Show Data Sources".
Select your query on the left, the data will appear on the right. Click on the upper left corner of the data to select all and then drag over the spreadsheet below. Be patient and all your data will appear...with column headers! This works almost flawlessly in 2.4.1, and I cant be happier...I've been looking for a way to export from Base (one that works) for years...hoorah!

Anyway, I hope that helps somebody. Enjoy :)

Nice post.

Yes, this late information in the most reliable way. In OpenOffice 3.0 you can click on the top of the DataSources pane icon "Data into text" and your data will appear in the spreadsheet. Most elegant way.

Thank you for this tip,

Nice... exactly the trick I was looking for!

The same thing works for queries. Thanks so much! This information was surprisingly hard to find!

Verify your Comment

Previewing your Comment

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

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. 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.


Post a comment

Comments are moderated, and will not appear until the author has approved them.

Your Information

(Name and email address are required. Email address will not be displayed with the comment.)

GetOpenOffice Consulting

Get Book Resources

Search This Blog