Users are authenticated using their Windows Login and can only work with the Excel documents for which they are authorized.
In SQL Spreads, data is automatically validated when users enter their figures and data from other Microsoft Excel documents can be pasted directly into the SQL Server connected document, but only if the data is valid.
In Windows Vista and Windows 7, features in the Power Pivot window are available on a ribbon, which is discussed in this topic.
In Windows XP, features are available from a set of menus.
As a Database Developer, I’m frequently asked to modify or populate data in a database table, usually from a list in an Excel spreadsheet.
Now there are several ways to import data into a database table – linked servers, ODBC, bcp, bulk insert, SSIS, etc., but server logistics can sometimes get in the way.
If you rename the column headers of the table in Excel, the changes will be updated in the linked table.
How can I Update the values given in excel sheet to my user table? If you are interested, I have built an Excel to SQL Server tool where end users update their data in Excel sheets on the intranet and the application will take care of parsing the Excel spreadsheet and export the data to a SQL Server table.
Obviously this method can only be used within Excel limitations, but I’ve had no problem using it to modify or populate several thousands of rows.
For example, using the Person table from the infamous Adventure Works sample database: You receive a request (in the form of an Excel file), to change the value of Email Promotion attribute to the corresponding value in the list: Starting in cell C2, enter the following text: =”UPDATE Person.
When you save the document, all your changes will be updated in the table in SQL Server.
To get the highest possible quality of data, several methods are used to guarantee the entered data: The new SQL Spreads trial is now available for download from this page.