Forgot to mention the most important feature of spreadsheet datasources:
Once you linked your e.g. pivot to a datasource, you always can refresh
it (usually Ritgh Click/Refresh), after a DB data change.
Kind Regards,
Alek
___
sqlite-users mailing list
Hi Dennis,
On 2019-10-17 02:11, Harris, Dennis wrote:
I sure this has been asked a 100 times but what is the best practice to get
data from SQLITE to Excel? I would like to have a pivot table that updates
upon open.
Excel and it's leading open source alternative - LibreOffice Calc, both
ha
On 17 Oct 2019, at 12:11am, Harris, Dennis wrote:
> I sure this has been asked a 100 times but what is the best practice to get
> data from SQLITE to Excel?
Use CSV file format as an interchange format. Save from SQLite as as a .csv
file, and import that file into Excel.
If you don't want to
I sure this has been asked a 100 times but what is the best practice to get
data from SQLITE to Excel? I would like to have a pivot table that updates
upon open.
Several people will use the file so I will save in a shared location.
Thanks in advance for any advice you can give me
Dennis
.
4 matches
Mail list logo