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/export-table-data-libre-office-base/ 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.