If so, where do I find a good overview of the SQL syntax possible when connecting to spreadsheets (thus not MySQL, HSQLDB. Are these limitations due to the designer ? But I didn't find any clear directives specific to spreadsheets. I know the SQL syntax in Base is dependant to the type of database. Now trying to get all the functionalities into LibreOffice. I am working with data that is originating from Exel files, combined with the DB possibilities of MS Query. impossible to add more than one table and make joins between them no aggregated functions (the list of functions in the query design window is empty) Advanced commands on the other hand do not seem to be available, as there is: I can list my tables and make some simple queries with them. odb file that connects to a Calc spreadsheet.
0 kommentar(er)
