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
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
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
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
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
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:
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,
7 matches
Mail list logo