All articles
-
Activate your license
-
Connect to SQL Server
-
Corporate deployment of SQL Spreads
-
Create SQL Server tables from within Excel
-
Demo: Financial forecasting in a business intelligence project
-
Download and install
-
Filtering rows from SQL Server
-
Filters - using a cell value in a filter
-
General FAQ
-
How to create drop down lists that show texts from another table
-
How to Update, Insert and Delete data
-
Implementation FAQ
-
Installing SQL Spreads
-
Intro to the Advanced Setup
-
Intro to the SQL Spreads Designer
-
Manually setup a mapping of Excel columns to fields in a SQL Server table
-
Manually setup an Import of data from SQL Server to Excel
-
Matched import - a high performance SQL solution
-
Matched import - a ready to use demo solution
-
Moving a document between servers, databases and tables
-
Pivoting data between Excel and SQL Server
-
Post processing - Adding a Custom Data Validation
-
Purchase FAQ
-
Saving and Refreshing to and from the database
-
Selecting a table or view
-
Selecting columns
-
Settings
-
Sharing a SQL Spreads Excel document
-
Sorting rows from SQL Server
-
SQL Spreads VBA interface
-
Start editing your data in SQL Server
-
Technical requirements
-
Transfer a license
-
Tree filters - a way for end users to select the data
-
Tree Filters - Adding a “Show All” item
-
Tree Filters - Adding Row-wise User access
-
Troubleshooting FAQ
-
Understanding 'Designer' and 'Data Editor' mode
-
Uninstalling SQL Spreads
-
Upgrading SQL Spreads to a newer version
-
What's new - release log