SQL Excel
Email Article
Suggest Link
SQL Excel adds database access to MS Excel. After installation an extra Excel Toolbar will be added to Excel with 5 different buttons providing access to all of the functionality of the add-in.
The first button on the SQL Excel Toolbar (the blue database icon) loads the SQL Excel Connections form where you can manage your connections.
The core functionality of the add-in is the retrieval of data into Excel, and the "SQL" button on the toolbar loads the SQL Entry form. This form allows for switching between different databases (and providers). To get the data from a database into Excel you execute a query or select statement on the form. There is a button to execute the SQL and display it in a grid on the form (which will appear on the bottom of the form if the "Run SQL and Preview in Grid" button is selected).
The vendor notes that SQL Excel can connect to all standard databases (MS SQL Server, MS Access, Oracle, MySQL, etc.).
SQL Excel is a freeware application, the vendor notes that it contains no ads, no spware, and no time limits.
product submission by Company Rep
| |||||||||||||
Data Management/Storage
 |
Latest category updates via our RSS feed
 |
|
Heroes Happen Here Launch Events Attend the upcoming launch of three powerful new products, take a test drive, meet the teams, and leave with promotional copies of Windows Server 2008, Microsoft SQL Server 2008, and Microsoft Visual Studio 2008. Register here. » Windows Server 2008 is Microsoft's most full-featured server operating system yet, so it's ironic that one of its most exciting new features is an install option that cuts out most of the other features. Paul Rubens explores why a Server Core installation makes a great deal of sense in many instances. » Windows Small Business Server 2008 and Windows Essential Business Server 2008 deliver all-in-one solutions to help fuel growth for customers and partners. » Bob Muglia, senior vice president, Server and Tools Division, discusses Microsoft's new interoperability principles and the steps the company is taking to increase the openness of its products. » Lutz Ziob, the general manager of Microsoft Learning, talks about how IT professionals can become certified heroes within their enterprises by getting trained and certified in Windows Server 2008. » |
|
