<div>
How about using csv format?<br />
<br />
Export see: <a href="http://ariejan.net/2008/11/27/export-csv-directly-from-mysql/" rel="ugc">http://ariejan.net/2008/11/27/export-csv-directly-from-mysql/</a><br />
<br />
<br />

</div>


How about using csv format?

Export see: http://ariejan.net/2008/11/27/export-csv-directly-from-mysql/ [http://ariejan.net/2008/11/27/export-csv-directly-from-mysql/]




<div>
all of the tables and data are loaded and then you can save the instance to disk. Instant transfer of EVERYTHING on your database &gt;:)
</div>


all of the tables and data are loaded and then you can save the instance to disk. Instant transfer of EVERYTHING on your database >:)

<div>
<div class="content wysiwyg-content">
I want to export and import a table, including structure, from mysql into an openoffice base file. What is the most efficient way to do this?<br />
<br />
I've tried exporting using sql statements but I can't seem to get the create table command to work in openoffice (using the top level sql dialog). It tells me that the command executed successfully but the table never shows up.
</div>
</div>


I want to export and import a table, including structure, from mysql into an openoffice base file. What is the most efficient way to do this?

I've tried exporting using sql statements but I can't seem to get the create table command to work in openoffice (using the top level sql dialog). It tells me that the command executed successfully but the table never shows up.

Most efficient method to import data into openoffice base

LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.

LibreOffice

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.