If you are uncomfortable with exporting to csv and importing csv from the command line, you could install DB Browser for SQLite, https://github.com/sqlitebrowser/sqlitebrowser. Then manually build your SQLite tables and cut and paste into them from the spreadsheet.
On Tue, Oct 1, 2019 at 8:58 PM Jake Thaw <jaket...@gmail.com> wrote: > You might like to consider the xlsx virtual table I wrote last year: > > https://github.com/jakethaw/xlsx_vtab > > Note that this only works for xlsx files, and may have unexpected > results in some circumstances (e.g. merged cells). > > On Wed, Oct 2, 2019 at 4:39 AM Winfried <codecompl...@free.fr> wrote: > > > > Hello, > > > > I need to import an XLS file into SQLite. > > > > The web site <https://sqlite.org/docs.html> doesn't seem to show > how, and > > searching the archives here <http://sqlite.1065341.n5.nabble.com/> > didn't > > help. > > > > FWIW, the data are in the file's first sheet, while other sheets only > > contain text infos about the data. > > > > Thank you. > > > > > > > > -- > > Sent from: http://sqlite.1065341.n5.nabble.com/ > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
