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 <[email protected]> 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 <[email protected]> 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 > > [email protected] > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
