How to Export Data From A LibreOffice Base Database Table hsqldb
How to export data from a LibreOffice (libre office) or open office base database table using sql and text tables to create a csv file on the Apple Mac file system, the process is similar for windows.
LibreOffice (Open Office) Base Programming Book (affiliate) https://amzn.to/3wdPFVq
I cover the hsqldb sql used in creating a text table in base, then the sql used to link this text table to a system file, when this sql "set table" query is executed it creates the csv file on your hard drive.
Finally I use an insert select query to populate the text table and which also populates the text file at the same time.
LibreOffice base (like open office base) is the only free open source database that is an adequate replacement for Microsoft Access, It's not as pretty but for your own projects it can get the job done.
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://buymeacoffee.com/seanjohnson
☕
The blog post for this video can be found at https://www.businessprogrammer.com/ex...
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
DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.
