Re: [sqlite] Import XLS file?

2019-10-03 Thread Dingyuan Wang
There is FreeXL (https://www.gaia-gis.it/fossil/freexl/index) may suit your need. 2019/10/2 02:58, Winfried: Simon Slavin-3 wrote 1) export your XLS data in CSV format 2) Use the SQLite shell tool to import the CSV data into your database Thanks. Is there a free (beer|speech) tool to

Re: [sqlite] Import XLS file?

2019-10-02 Thread sky5walk
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

Re: [sqlite] Import XLS file?

2019-10-01 Thread Jake Thaw
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 wrote: > > Hello, > > I need

Re: [sqlite] Import XLS file?

2019-10-01 Thread Warren Young
On Oct 1, 2019, at 12:46 PM, Simon Slavin wrote: > > 1) export your XLS data in CSV format > 2) Use the SQLite shell tool to import the CSV data into your database Beware that SQLite’s CSV import requires that the imported data have the same number of columns as the table you’re importing it

Re: [sqlite] Import XLS file?

2019-10-01 Thread Simon Slavin
On 1 Oct 2019, at 7:58pm, Winfried wrote: > Is there a free (beer|speech) tool to convert an XLS file into CSV, for > Windows or Linux that you would recommend? Not really the topic of this forum. XLS is Microsoft Excel format. Excel has an 'export as CSV' feature. So if you used Excel to

Re: [sqlite] Import XLS file?

2019-10-01 Thread Winfried
Simon Slavin-3 wrote > 1) export your XLS data in CSV format > 2) Use the SQLite shell tool to import the CSV data into your database Thanks. Is there a free (beer|speech) tool to convert an XLS file into CSV, for Windows or Linux that you would recommend? -- Sent from:

Re: [sqlite] Import XLS file?

2019-10-01 Thread Simon Slavin
On 1 Oct 2019, at 7:47pm, Winfried wrote: > I need to import an XLS file into SQLite. I recommend a two-part solution, because so many programs understand CSV file format. 1) export your XLS data in CSV format 2) Use the SQLite shell tool to import the CSV data into your database For part 2,