SQL Server for Microsoft Excel
Import, edit and generate data for SQL Server in Excel 2007-2013. Free download
With SQL Server for Excel you can easily view, edit and update records in a Microsoft SQL Server database table without using SQL Scripts or SQL Server Management studio:
Easily edit and generate SQL Server data in Excel
If you ever wanted to use Excel’s drag-and-drop and copy/paste functionality to update your SQL Server records, this add-in is for you. With SQL Server for Excel, you can easily open data contained inside a Microsoft SQL Server database table and update the existing records.
The changes you make can then either be automatically applied from within Excel by simply clicking a button or saving to a file to be run on the SQL server at a later stage.
SQL Server for Excel also provides the functionality to insert demo or sample information into an existing SQL table. Simply select any CSV file containing data, select which column’s details to use, highlight the cells you wish to update and click the “Insert random data into selection” button. SQL Server for Excel will then automatically select random values from the CSV file and insert it into the Excel selection. The changes can then either be saved to a file or immediately applied to the database.
This is an ideal feature for developers who wish to demo their product but who do not wish to display real client data during the demonstration.
SQL Server for Excel screenshots
Quickly and easily connect to a SQL Server database.
See a list of database tables and simply double-click to open the data in Excel.
Select any CSV file with sample data, specify which column in the file to use, select the cells in Excel where the data should be written to and random values will be generated.
Please note, this is a BETA release
SQL Server for Excel system requirements:
- Windows 8 (32- and 64-bit)
- Windows 7 (32- and 64-bit)
- Windows Vista (32- and 64-bit)
- Windows XP (32-bit)
- Windows Server 2003, 2008, 2012
- .NET Framework 4.5 must be installed.
- Microsoft Excel 2013 (32- and 64-bit)
- Microsoft Excel 2010 (32- and 64-bit)
- Microsoft Excel 2007