'Keep SQLite table synced using data taken from Excel sheet (without passing through CSV conversion)

I am looking for a way to use one excel sheet as data source for a SQLite DB. My goal is to have the database table updated when I change something in excel, automatically would be the best of course, or manually by any simple mean: one macro, one prompt command, batch script whatever, as long it doesn't require more than a couple of mouse clicks.

I have explored other solutions like passing through CSV files and it is not viable, it takes less time to manually update the data directly into SQLite...

Thanks in advance.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source