Can I use different data sources in Base?

[gee]

I have data coming as csv and html files from different sources. An updated file may arrive every day or a few times a week. The files contain similar fields, but the order, formatting and mapping may be different.

I want to be able to access the data in these files in base.

I also want to create additional tables, and manually enter some data.

I want to be able to get data from all these sources (ideally all data from all the files should appear in one view), filter, group, and create reports. I could do this with SQL if the data sources were all available.

Finally, I will need reports with table-like output and reports with summaries and diagrams.

I am not sure whether base can combine all these things, and if yes, what are the options. I would like to know what is the best approach.

I created a database, created tables for the manual data, I can create views, but can’t access the data in the csv files.
I created another database, which uses the csv files and shows them as tables, but in this one I can’t create a new table, and I can’t create views.

It is not clear what to do next.

Thanks is advance for all the help

[Regina]

Do you use an external database engine or do you want to use the embedded HSQLDB?

[gee]

I do not use any external DB engine so far. I was hoping I can use Libreoffice base with HSQLDB. However, if that doesn’t work, I am OK to start using something external.

[Regina]

The embedded HSQLDB can use external csv files for generating tables parallel to other tables. However there is no wizard for it, but you need to create the table manually using SQL commands. You find it in the HSQLDB User Guide in chapter 6. Hsqldb User Guide

[gee]

This looks promising. I will experiment with it.
Thank you