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. Matched import - a high performance SQL solution

  19. Matched import - a ready to use demo solution

  20. Moving a document between servers, databases and tables

  21. Pivoting data between Excel and SQL Server

  22. Post processing - Adding a Custom Data Validation

  23. Purchase FAQ

  24. Saving and Refreshing to and from the database

  25. Selecting a table or view

  26. Selecting columns

  27. Settings

  28. Sharing a SQL Spreads Excel document

  29. Sorting rows from SQL Server

  30. SQL Spreads VBA interface

  31. Start editing your data in SQL Server

  32. Technical requirements

  33. Transfer a license

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

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

  36. Tree Filters - Adding Row-wise User access

  37. Troubleshooting FAQ

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

  39. Uninstalling SQL Spreads

  40. Upgrading SQL Spreads to a newer version

  41. What's new - release log

Feedback and Knowledge Base

(thinking…)