Hi I’m following this YouTube Tutorial on how to create a Rainfall database from a large rainfall dataset in LibreOffice Base. I managed to create the “tblRainFall_Live” using the following SQL command
create text table “tblRainFall_Live”
(“ID” int, “Time” Varchar(20), “Rate”
float, “Daily” float, “Weekly” float,
“Monthly” float, “Yearly” float)
But when enter the following SQL command
set table “tblRainfall_Live” Source
“2019_Rainfall.csv;
ignore_first=true;encoding=utf-8”
I get the message “1: user lacks privilege or object not found”
The database is using the Split_HSQLDB_Wizard_v3c.odb & I suspect I don’t have user permission or something for split database. I got it to create the database & driver folders & it has saved 2 files in the database folder; “mydb.properties” & “mydb.script”. I think I got it to connect to an existing database at some stage but not sure if that was the right thing to do. Obviously I’m a LibreOffice Base noob;-) I’ve posted some comments on the YouTube video as well if you check it out.