|
The points below gives you a brief overview of the SQL Excel Add-in.
- SQL Excel adds easy database access to MS Excel. SQL Excel has a very easy to use interface and you will only take minutes to set up and start to use. After install an Extra Excel Toolbar will be added to your Excel. This toolbar holds 5 different buttons and gives you access to all of the functionality of the Addin.
- SQL Excel can connect to all standard databases so you can easily consolidate data from different data sources (MS SQL Server, MS Acces, Oracle, MY SQL etc.) The first button on the SQL Exel 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 retrieveal of the data into Excel and the "SQL" button on the toolbar loads the SQL Entry form. This form has been setup to make it easy to switch 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).
- Last but not least, SQL Excel is a freeware application. SQL Excel is a Genuine Freeware! Absolultely NO Ads, NO Spware, No Time Limits.
|
