Welcome to SQL Spreads Knowledge Base
    • Dark
      Light
    • PDF

    Welcome to SQL Spreads Knowledge Base

    • Dark
      Light
    • PDF

    Article Summary

    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

    00:00 Intro 
    00: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
    00:00 Intro 
    00: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 
    00:00 Intro 
    00: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 into Excel 
    02:22 Custom SQL Filter  to filter the rows loaded from SQL Server into Excel 
    02:35 Tree Filters - let the user filter which rows to load from SQL Server into Excel 
    02:54 Sort the rows loaded from SQL Server into Excel 
    00:00 Intro 
    00: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