![]() On the Advanced tab I clicked the "Class Path." buttonĪnd then added the following JAR file using the "Add Archive." button: /home/gord/Downloads/JDBC/UCanAccess/loader/ucanload.jar I launched LibreOffice (not Base, just LibreOffice itself) Note: When unzipping the distribution file be sure to specify "Keep directory structure" (or similar, depending on your unzip tool) so the folder structure appears as in the screenshot above. Then I downloaded UCanAccess ( bin.zip file) and unzipped it into the folder ~/Downloads/JDBC/UCanAccess One-Time Setupįirst, I installed LibreOffice Base sudo apt-get install libreoffice-base Here's how I did it on a clean install of Ubuntu 20.04 LTS. We can use the UCanAccess JDBC driver to connect to Access databases (.mdb and. This would have been extremely slow if done from the non-native DB.Ĭredits to the people at an thread who figured this out.Open Access database (accdb) ubuntu 20.04 Libreoffice Base As a consequence, you can’t use the same name for the CSV file as an existing table.Ĭopy the table into Calc and export it to CSV. Note that this actually creates an external table in the database (if it doesn’t show up, reload the database). This command only works on a native ODB because Access’s SQL engine doesn’t support the INTO TEXT construct. SELECT * INTO TEXT 'filename_without_ext' FROM 'TableName' Run the following SQL command (Tools → SQL…). This may sound arbitrary, but it’s necessary otherwise, the next step would either be impossible or unbearable.īase doesn’t have an “export to CSV” menu entry. Just don’t try to move around the files.Ĭopy the tables over into a different, native ODF database (ODB) file. You have to create a new ODB file that connects to the MDB file as a “remote” database. This post explains the steps necessary to convert a Microsoft Access database file into CSV, using (or LibreOffice) Base.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |