|
SQL Excel V1.2 Released - May 21st |
|
|
|
Wednesday, 21 May 2008 |
May 21st, 2008 - new much improved version is available (compatible and tested on Excel 2000, 2002/XP, 2003 and 2007). This is an Excel for Windows add-in so it wont work on a mac. - Easy to import data to Excel from SQL Server, MYSQL, Oracle, Sybase, Microsoft Access, FireBird / Interbase, DB2, Excel Workbooks etc. Works with any ODBC compatible data source. Use the add-in to quickly import data and then use Excel's power to analyse it in more detail if needed.
- Data retrieval is fast (very good speed performance..). The add-in is for running data retreivel queries (SELECTS) and is not for running action queries (CREATES, INSERTS, DELETES, UPDATES..).
- Small Add-in Size - has small disk and memory footprint. The core DLL of the add-in is around 300k. It wont bog down your Excel like add-ins can sometimes..
- Add-in user interface is implemented via a small toolbar which will be added to your excel. The toolbar wont take up too much space in Excel and you can move it to where you want it. A new feature in this release is the Connection Profile Combobox. So it is possible to select a connection directly from the toolbar and hit the "SQL" button and you will connect to the database and view the available selectable objects in the main SQL Excel Form. If you hit the "SQL" button with the default entry "SQL Excel Toolbar" you will load the main Form without any connection being opened (use this when you want to set up some new or manage existing connection profiles).
- Easy to build complex queries using the visual interface. SQL Excel implements two way query building so you can (i) build queries visually by dragging/clicking and (ii) build queries by manually typing in the SELECT statement. The main form of the add-in incorporates alot of functionality but is still easy to use. The form is a bit too large to show here in entirety but you can see the left hand side of the main form below. The un-show part of the form has the Excel related functionality (where you can specify to include headers, specify Excel formatting etc).
|
|
Last Updated ( Monday, 02 June 2008 )
|
SQL Excel 
Delicious
Furl it!
Spurl
NewsVine
Reddit
YahooMyWeb