Retrieving Data From CSV Files With HSQLDB

To retrieve data from CSV (comma-separated values) files using the text tables, feature of HSQLDB, configure datasources like this:

...

6. Use your database custom fields with values populated from the csv files.

Other Methods of Loading CSV Data

Modern databases have the ability of mounting a CSV file as an individual table, which can be queried afterwards. Please refer to your database documentation or ask your DBA.

...