How to import a excel file to the h2 database?

Question

I have an excel sheet with data stored in ten columns and a large number of rows. I would like to import the content of the file in an H2 database. what is the procedure for this? can I import the excel file as a whole or do I have to write some specific code to handle the content row by row ?

Solution

Export your file to CSV and then use the H2 function to read CSV file.

This is described in the H2 documentation.

Comments

[LE GALL Benoît]

The links is broken :'(