How do I add the database program when I already have Libreoffice Win 10?
I have an existing file in spreadsheet format that I want to convert or use as a database.
menu:Help>About…
Click the button in the middle.
Paste the clipboard content into your next message, so we know your operating system at least.
Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: CL
Want to convert existing sc file so I don’t have to re-enter everything.
Unless you unselected the Base component during the installation process, you have the Base component installed.
Base is not a database. Base is a frontend to work with databases.
What is an sc file? If it happens to be some kind of database in a file, you need an ODBC or JDBC driver for this kind of database. Then you will be able to connect the file to a Base document. The Base document will show the tables and columns of that database.
Sc = spreadsheet file. I found out where I can create a database file but have not done it yet. I go menu: File, new, database, create database?
I want to use some of the entries in my spreadsheet to input to a database file if possible.
Not sure of what your technical terms mean as I am a newbie at this.
Yes, that’s right. You get a HSQL database embedded in the Base document. This database is installed to a temporary directory when you access it and it is wrapped back into the document when you close a session. Good enough for drafts and demos. Can be converted to a stand-alone HSQL database.
Copy&Paste from Calc to Base is possible, but fails if the spreadsheet data are inconsistent. Most spreadsheets are inconsistent.