I have a problem, but also a weird solution
After clicking on the libreoffice Base Icon, then “Connect to an existing database”, then “Text” in the drop-down menu, then “Comma-seperated value files (*.csv)” and finally on “Browse”, I can’t seem to connect to csv files. They are all highlighted in grey , and I don’t know why.
Anybody have an idea?
The only solution I found was to create a file, place the csv file in it, copy the path in the “Browse” bar, choose the correct delimiter for the file, and click on “Next”, click on “No” when the “Confirmation” Message Box appears, choose “Comma-seperated value files (*.csv)”, next “Next” and “Finish”.
If you do this for one file in a folder that has other files, by doing the exact same thing, you connect to all the files in the folder, but some files won’t be displayed correctly depending on the delimiter you choose.
IMPORTANT: when inserting the path into the “Browse” bar, the path must have NO SPACES (or other certain characters maybe?), other wise the connection will not work.
Edit: not sure why LIMIT doesn’t work though.
LibreOffice Version 126.96.36.199 on macOS Mojave Version 10.14.3