Intro to the SQL Spreads Designer
Intro
This part of the knowledgebase will go thorough how you create and setup a SQL Spreads Excel document to maintain data in SQL Server.
You can connect a SQL Spreads Excel file to multiple SQL Server tables by adding the new SQL Server table to a new sheet in Excel.
All settings are stored in the document
When you create a new SQL Spreads document all the setup that you do in the SQL Spreads Designer is stored within the Excel file. So you can easily share your new solution by just sending the file to other users (they will need to have the SQL Spreads Add-In installed with a valid license).
One SQL Server table per Excel sheet
SQL Spreads in Data Editor mode
For non-technical end user, SQL Spreads can be installed in Data Editor mode where all the configuration options like the Designer are locked down. A Data Editor can only work with data in a SQL Spreads document created by a Designer.
Data Editor users will need a license. To activate SQL Spreads in Data Editor mode, select the special Data Editor license key which was included in the license key email received after purchase (for subscription customers, contact support@sqlspreads.com to activate a subscription in Data Editor mode).