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