When SQL Spreads is connected to SQL Server, the available Databases, Tables, and Views will be shown in the Database Tab in the SQL Spreads Designer.
Select a Table or View in the list in the Database tab to load it into Excel:
To load multiple tables into the same Excel document, switch to an empty Worksheet in Excel and select the second table there.
To update data in SQL Server Views you will need SQL Spreads Pro or a higher plan
Preview of 50 rows in the SQL Spreads Designer
When the SQL Spreads Designer is opened, SQL Spreads will preview only the first 50 rows in the table.
You can turn off the Preview and also see the total number of rows in the table at the top in the Columns tab in the SQL Spreads Designer.
Turn off the Preview of 50 rows
To turn off the preview in the SQL Spreads Designer and show all rows, click the Show all rows checkbox.
When you close the Design mode and click Refresh, all rows from the table will be loaded into Excel.
Data Editor mode users will automatically see all data regardless of the Preview configuration in the Designer.
Quickly filter your databases and tables
If you have large numbers of databases and tables in your SQL Servers it can be hard to find a specific table or database.
SQL Spreads has a database and table filtering feature that makes it really easy to find the database and table you are looking for.
Filter the list with databases and tables
-
Click the filter icon in the Database tab in the Designer to show the filter fields:
-
Enter a filter for either the databases or the tables to be shown, or both if needed:
-
The tree-list with databases and tables will be instantly updated to reflect your filter criteria.
SQL Spreads will remember the last entered filter criteria and will automatically show the filtered list next time you open Excel.
To clear the filter and show all databases and tables
To clear the filter and show all databases and tables, click the filter icon with the red cross:
Selecting Key columns for the table
SQL Spreads requires a unique key for each row in the selected Table or View. The key can be a single column or a combination of multiple columns.
If the key columns in the database are either an Identity column or a Primary Key column, SQL Spreads will automatically detect these columns as key columns.
The key columns are marked with a key symbol in the left-side row header:
When you load a new table into SQL Spreads, and the key column(s) are not automatically detected, you will see a key selection dialog to manually specify which columns are the key column(s).
There cannot be any duplicate data in the key columns that you are selecting. If there is no combination of key columns that is allowing you to continue, check that there are no duplicates in any of those rows in your data in SQL Server and if there are, remove the duplicates before trying the combination of key columns again.
Manually selecting the key columns
To manually select the key columns:
- Click the right-side cog in the Columns tab:
- Then click the Select key columns button:
- You will now see the Key selection dialog and can check the columns that are your key columns:
To update data in SQL Server Views, see Working with SQL Server Views.