Re: [sqlite] Excel Pivot Table

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

Re: [sqlite] Excel Pivot Table

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

Re: [sqlite] Excel Pivot Table

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

[sqlite] Excel Pivot Table

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 .