Gnucash: how to convert a huge XML data file into sqlite?
Apparently, gnucash can do this conversion. Open your XML datafile and then File->Save As and choose to save as an Sqlite file. This is also listed in the GnuCash instruction manual in Chapter 2, The Basics.