- Print
- DarkLight
- PDF
Welcome to SQL Spreads Knowledge Base
- Print
- DarkLight
- PDF
Intro
SQL Spreads is a lightweight Data Management solution for SQL Server. With the use of Excel as the front-end for managing the data in SQL Server, users can get up and running in minutes.
Built-in Data validation, Drop-Down lists with key lookups, conflict detection, and change tracking guarantee your corporation's data quality.
The knowledgebase will help you to get started and learn all the details about how to create your data management solution using SQL Spreads.
SQL Spreads Videos
Get up and running00:00 Intro00:11 Download the free SQL Spreads trial 00:23 Install the SQL Spreads Excel Add-In 00:40 Connect your SQL Spreads Excel document to SQL Server 00:52 Select your SQL Server table to load into Excel 01:02 Update your data in Excel and save back to SQL Server 01:15 The SQL Spreads Knowledgebase | How to evaluate and purchase SQL Spreads00:00 Intro |
Create your first SQL Spreads document00:00 Intro00:15 Create a SQL Spreads documents 00:50 Connect the Excel document to SQL Server 01:16 Select SQL Server Authentication method 02:24 Select your Table or View 03:06 Setup how your SQL Server table is shown in Excel 03:45 Saving and sharing your document | Fine-tune your SQL Spreads document00:00 Intro00:17 Select which columns to show or hide 00:31 Make columns Read-Only 00:45 Change the name of a column 00:52 Arrange columns order 01:05 Create lookups with drop-down lists for key columns 01:37 See column details like data type, length etc. 01:47 Set a default value for empty cells 02:11 Column Filter to filter the rows loaded from SQL Server 02:22 Custom SQL Filter to filter the rows loaded from SQL Server 02:35 Tree Filters to filter which rows to load from SQL Server 02:54 Sort the rows loaded from SQL Server into Excel |
Create Drop-down with texts for Key values00:00 Intro00:15 Lookup a key value in a database table 01:20 Lookup a key value in a simple list of key-value pairs |
Contact support
If you need any help, feel free to contact SQL Spreads support at:
support@sqlspreads.com
Contact sales
If you have a sales inquiry please contact sales at:
sales@sqlspreads.com