All articles

← Knowledge Base

  1. Activate your license

  2. Connect to SQL Server

  3. Corporate deployment of SQL Spreads

  4. Create SQL Server tables from within Excel

  5. Demo: Financial forecasting in a business intelligence project

  6. Download and install

  7. Filtering rows from SQL Server

  8. Filters - using a cell value in a filter

  9. General FAQ

  10. How to create drop down lists that show texts from another table

  11. How to Update, Insert and Delete data

  12. Implementation FAQ

  13. Installing SQL Spreads

  14. Intro to the Advanced Setup

  15. Intro to the SQL Spreads Designer

  16. Manually setup a mapping of Excel columns to fields in a SQL Server table

  17. Manually setup an Import of data from SQL Server to Excel

  18. Moving a document between servers, databases and tables

  19. Pivoting data between Excel and SQL Server

  20. Post processing - Adding a Custom Data Validation

  21. Purchase FAQ

  22. Saving and Refreshing to and from the database

  23. Selecting a table or view

  24. Selecting columns

  25. Settings

  26. Sharing a SQL Spreads Excel document

  27. Sorting rows from SQL Server

  28. SQL Spreads VBA interface

  29. Start editing your data in SQL Server

  30. Technical requirements

  31. Transfer a license

  32. Tree filters - a way for end users to select the data

  33. Tree Filters - Adding a “Show All” item

  34. Tree Filters - Adding Row-wise User access

  35. Troubleshooting FAQ

  36. Understanding 'Designer' and 'Data Editor' mode

  37. Uninstalling SQL Spreads

  38. Upgrading SQL Spreads to a newer version

  39. What's new - release log

Feedback and Knowledge Base

(thinking…)