Move the split database file into the folder that you want your application to reside in. The attached YouTube tutorial will take you through the setup in detail. Put the database file in the directory or folder that you want, double click on it and follow the onscreen prompts and you’ll soon be good to go. You can access databases such as Microsoft SQL Server, Microsoft Access, Oracle,, DB2, Derby, InterBase and Sybase ASE from Base and Calc even. You can download the split database setup file here, it’s actually just an OpenOffice or LibreOffice database file with some macro code that sets everything up for you. There are many ways to import data into LibreOffice base, I’ll start off here with the most simple – if not the most robust way, which is importing data via the user interface.

If you find this article or videos really helpful, then consider grabbing me a coffee, it takes a lot of work and expense to keep this site going, the more caffine I have the harder I can work.Īnd if you do grab me a coffee (just click anywhere on this green area), thanks for your support 😉 First Create The Split Database Arranging Data With a few mouse-clicks, you can reorganize your spreadsheet to show or hide certain data ranges, or to format ranges according to special conditions, or to quickly. Wanna grab me a coffee? – Then Click This Green Box LibreOffice Calc lets you drag-and-drop tables from databases, or lets you use a spreadsheet as a data source for creating form letters in LibreOffice Writer.

Openoffice calc database