Ask Your Question

export option in libreoffice database is not working

asked 2019-08-07 08:26:23 +0200

kvp gravatar image

I have MSaccess accdb file and able to connect it using base. It has 90+ tables. The option file->export is disabled. There is no way of exporting the db. Is there a way of exporting all the tables in one go ?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-08-07 10:11:25 +0200

lazarus477 gravatar image

updated 2019-08-07 10:22:09 +0200

To export data from Base you need to use Calc, or the SQL command window.

Using Calc

I refer you to this documentation: Importing and Exporting Data in Base.

Generally the procedure is to copy each table to an individual spreadsheet. Finally you export each spreadsheet sheet to a CSV file.

Using SQL command

From the Tools menu choose Tools->SQL. In the SQL command window that opens, enter the command SCRIPT followed by a path to the destination file, to store the export in, such as /tmp/export.sql. Make sure the path exists. This will result in dumping the entire database to an .sql file for importing into other database software, or back into another Base document.

Reference: Can anyone help me convert my ODB file to SQL?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-07 08:26:23 +0200

Seen: 55 times

Last updated: Aug 07