LibreOffice Base Split Database Tutorial
Here I explain a real world data processing example using a LibreOffice base split database with Sql and Text Tables to import and transform an Excel File containing 104,916 rows of data to 365 rows without using programming code.
In this video you'll learn how to create a Libre Office Split Database (which is much faster and more stable than the standard embedded database).
I show you how to
1) Get the Split Database wizard
2) Create the split database
3) Convert an existing Excel File to CSV text file for importing into LibreOffice base, I do this with both Excel and LibreOffice Calc
4) How to use SQL to create a LibreOffice Base text table to create a "live" link to the text table.
5) How to create a duplicate table using sql in order to copy the data from the live linked table into a standard non linked table (using an insert select sql query)
6) How to split out a date column to isolate the day and the time in seperate fields using sql update statements.
7) Create an output table to export the data out of LibreOffice base to a "report" csv file" so that the result can be read in LibreOffice base, Calc or Microsoft Excel.
Related Split Database Video Split database video https://www.youtube.com/watch?v=XQtKXPvckOg
LibreOffice Base complete playlist (all lessons): https://www.youtube.com/watch?v=k6XUpvYwuPg&list=PLQORZjfSPqSkFSFHR32WlfXhen0C2HyAi
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee...
https://www.buymeacoffee.com/seanjohnson
☕
Code to make date and photo feature work can be found at https://www.businessprogrammer.com/go/116
Resources
============
LibreOffice Base (book is titled OpenOffice) PROGRAMMING https://amzn.to/3sSK3xg
Video Production
===============
Sony Camera: https://amzn.to/3mqyqfu
Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum
Microphones
-----------
Screen Casting: https://amzn.to/3a2TnHN
Microphone and Arm : https://amzn.to/3iwvL2S
Talking To Camera: https://amzn.to/3FqXI6b
Video Kit
-------------
Lights
Elgato video Lights: https://amzn.to/3sSK3xg
Background Light: https://amzn.to/3uTXyPh
Note Taking
-----------
Rocketbook reusable notebook https://amzn.to/3sSK3xg
#libreoffice #openoffice #businessprogrammer #cheltenham
DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I might receive a small commission.
Видео LibreOffice Base Split Database Tutorial канала Sean Johnson
In this video you'll learn how to create a Libre Office Split Database (which is much faster and more stable than the standard embedded database).
I show you how to
1) Get the Split Database wizard
2) Create the split database
3) Convert an existing Excel File to CSV text file for importing into LibreOffice base, I do this with both Excel and LibreOffice Calc
4) How to use SQL to create a LibreOffice Base text table to create a "live" link to the text table.
5) How to create a duplicate table using sql in order to copy the data from the live linked table into a standard non linked table (using an insert select sql query)
6) How to split out a date column to isolate the day and the time in seperate fields using sql update statements.
7) Create an output table to export the data out of LibreOffice base to a "report" csv file" so that the result can be read in LibreOffice base, Calc or Microsoft Excel.
Related Split Database Video Split database video https://www.youtube.com/watch?v=XQtKXPvckOg
LibreOffice Base complete playlist (all lessons): https://www.youtube.com/watch?v=k6XUpvYwuPg&list=PLQORZjfSPqSkFSFHR32WlfXhen0C2HyAi
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee...
https://www.buymeacoffee.com/seanjohnson
☕
Code to make date and photo feature work can be found at https://www.businessprogrammer.com/go/116
Resources
============
LibreOffice Base (book is titled OpenOffice) PROGRAMMING https://amzn.to/3sSK3xg
Video Production
===============
Sony Camera: https://amzn.to/3mqyqfu
Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum
Microphones
-----------
Screen Casting: https://amzn.to/3a2TnHN
Microphone and Arm : https://amzn.to/3iwvL2S
Talking To Camera: https://amzn.to/3FqXI6b
Video Kit
-------------
Lights
Elgato video Lights: https://amzn.to/3sSK3xg
Background Light: https://amzn.to/3uTXyPh
Note Taking
-----------
Rocketbook reusable notebook https://amzn.to/3sSK3xg
#libreoffice #openoffice #businessprogrammer #cheltenham
DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I might receive a small commission.
Видео LibreOffice Base Split Database Tutorial канала Sean Johnson
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel Advanced Filter To Find Empty or Blank Cellshow to create a vba login form in excel vbavba advanced filter data analysisPower Up Your Database with Firebird Server & LibreOffice BaseExcel VBA Advanced Filter ExamplesExcel VBA MsgBox Explained In Detailvba excel consolidate multiple worksheetsexcel vba macro recorder to parse text using text to columns vba excelDownload and install xlwings and python for Excel VBAUse Power Query To Import Text File into ExcelHow To Create a VBA Form In ExcelExcel VBA Advanced Filter Database FormLibreOffice Base Insert Dynamic ImageLibreOffice Base How To Create A Database TableHow To Create A LibreOffice Base Form with Sub FormExcel VBA Get Range Reference To Last Row With Dataconsolidate data from multiple workbooks excel vbaHow To Make An Excel VBA Listbox Behave Like A GridPower Query Using VBA and Sql To Import Text File.LibreOffice Base Database Tutorial No Code Required