This is a tool that can help with transfer of Excel data to SQLite database.
XlsToSqlite is a data conversion tool that helps import of Excel data to SQLite database. Configuring the transfer through the interface is simple and all you need to do is identify the source fields and destination fields by simply clicking the terms. You need to specify the schema and table to be selected. Type of transfer can be set easily either for replacement of existing data or filling-in of fresh data, etc. The progress bar provides visual indication of the transfer status; you get a percentage indication as well as actual number of records transferred. That is a very useful feedback about the transfer. Logs record details of transfer events. In addition to the events of successful transfer of a record, it will give you some indication as to the cause of a problem if there is one.
The interface is simple and the IT and DBA types who are the targeted users should find no problems at all to start using it. Anyway a wizard is available to make things easy when you get started. With Unicode support, this tool is able to handle data in most languages of the world. When you have transfers on a regular basis, the ability to save session parameters and the ability to load them again for a different session helps a lot. Users who have become experienced with the tool will be able to derive productivity gains through the use of the command line interface provided. Combined with a task scheduler the burden of routine transfers can ease quite a bit. This is a utility for the Windows platforms including Windows 2000, XP, 2003, Vista, 2008, 7, and 8. This is a handy tool and is a good product.