The CSV file is imported into the Base database. Apache OpenOffice Base It helps user to open, view, edit and create MDB files when no Microsoft Access. It lets you modify, search, sort, import, filter and export MDB files.

It can also open various other types of MS Access files easily. When prompted to create a primary key, click Yes to create or No to ignore. LibreOffice Base You can create,edit and view MDB file freewith LibreOffice Base. Type in a new field name and change the type or length if necessary. In the Table name field, type in a new name.

Simply drag and drop the CSV table to the newly opened Base window's Tables icon or pane.

Now, create or open up an existing Base database, e.g.

The database is created and the CSV file can be seen as a table. Set of libraries and utilities for reading Microsoft Access database (MDB) files.

If necessary, choose the CSV type e.g. libreoffice-bin-debug, LibreOffice, a full office productivity suite.

Select the folder containing the CSV file, e.g.

In the Path to text files field, click Browse.

Toggle on Connect to an existing database.

From the Start button, select All Programs | Libre Office 4.0 | LibreOffice Base.

The example CSV file is shown in the screenshot below. Start wizard with File New Database or use item LibreOffice Base from Windows (German) Startmenü, or use item Database in LibreOffice Quickstarter.

We also use QGIS to map our exploration databases, so it made sense to me trying to connect them. In the past we managed our exploration data as Excel files, and that has major data loss and corruption risks. It turned out that I could copy and paste the CSV file via a LibreOffice Calc spreadsheet, but a better way is to simply open the CSV file directly, as shown below. Libreoffice offers a very complete package for office applications. I wanted to do the same thing using Base. One of the usual task I do with Access is to import a Comma Separated Values (CSV) file into an Access *.mdb database, where I could run some SQL queries on it.

LibreOffice Base can also open Access databases using a UCanAccess plugin.After using Microsoft Access for many years, I decided to give LibreOffice Base a spin. KEXI Project - 'Microsoft Access for Linux' - Home 'Kexi' is an excellent option in the Software Manager or Synaptic Package Manager (SPM). There are a few good posts already in this forum on this topic if you search for them. If you run ' inxi -Fxzd' and ' lsusb' from the console terminal prompt, highlight the results, copy and paste them back here, that should provide enough information. It would help to know more about your system setup. I just read your post and the good replies to it.

Mdb libreoffice