This document contains the details about the latest release of SQL*XL. A new release is first posted here. After a week the release is made public as mainstream download of SQL*XL if there are no reported problems.
 
SQL*XL 5.0.1 (10/Aug/2010)  

• Better support for the ACE Access driver in the SQL editor
  
• Improved support for substitution variables
  
• Improved MyODBC connection stability.
  
• Fixed error in update statement in SQL editor
  
• Advice message when using bind variables with Active Directory
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1280383020/0#4
  
• A new SQL error dialog was added to clearly view SQL errors and to abort a SQL script.
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1280750394/0#0
  
• Added support for the Oracle SQL statement: merge
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1142408952/0#1
  
• Better support for spreadsheets with array formulas.
  
• Compatibility fixes for Excel 2010 x86 (32 bits)
  
• Compatibility fixes for Windows 7 (32 & 64 bits)
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1281447026/0#0
  

 
SQL*XL 4.3.24 (26/Feb/2010)  
(Universal edition: www.oraxcel.com/software/sqlxl4324.exe)
(Standard edition: www.oraxcel.com/software/sqlxl4324std.exe)

• Inserting into SQL Server's IDENTITY columns
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1266495301
  
• Signing the software with a new digital certificate. Expiry 2012.
  

 
SQL*XL 4.3.21 (12/Feb/2010) (www.oraxcel.com/software/sqlxl4321.exe)

• Automatic conversion of spaces in column names to underscores.
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1261345568
  
• The SQLFunction cell function works with SQL Server databases:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1262197104
  
• Pass Excel parameters to SQL Server functions
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1262197104#1
  

 
SQL*XL 4.3.20 (20/Dec/2009)  

• Stabilised connections to MySQL databases
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1260186489
  
• New digital signature that includes the Thawte Root certificate.  
  
• One step installation: .exe installer.
  

 
SQL*XL 4.3.18 (25/Nov/2009)  

• Better support for SQL Server  
  Improvements in the SQL editor - Better handling of CLOB columns
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1256726389/0#0
  
• Stop SQL*XL gracefully when macros are stopped.
  
• Added a dialog to select a table from a list to Multiple Rows Insert dialog
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1256900603/0
  
• New digital signature that includes the Thawte root certificate
  
• Improved setup program to remove unnecessary warnings about version conflicts.
  

 
SQL*XL 4.3.17 (05/Oct/2009)  

• Added commit feature to multiple rows update
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1242568900/0#0
  
• Avoided a rare compile error when recording marcos
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1243673429/0
  
• Added a warning to prevent #name formula errors
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1250925903/0
  
• Control how many bytes are returned from a CLOB column
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1252325586/0
  
• Built in support for nvarchar2 columns in the Create Table dialog
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1254478455/0#0
  

 
SQL*XL 4.3.16 (20/April/2009)  

• Added parameters to manage network latency
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1239988330
  

 
SQL*XL 4.3.15 (5/April/2009)  

• Performance Insert Multiple Rows function increased by 10%
  
• Multi Insert Silent after insert errors  
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1235251503/0
  
• Added progress indication to Create Table dialog
  

 
 
SQL*XL 4.3.12 (06/Feb/2009)  

• Output of decribe table command: replaced data type number with data type description.
  
• Support for the new Access 2007 (.accdb) database
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1228742458/0#0
  
• Better support for SQL Server databases when connecting to databases with the same name:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1230372973/0#5
  
• Support for Pervasive databases
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1230564279/0#0
  
• Support for MySQL 5.1
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1231064159/0#0
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1231064012/0#0
  
• Support for MySQL stored procedures
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1231070199/0#0
  
• Support for Oracle 11g's binary_float and binary_double columns
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1231429709/0#1
  
• Support for the Oracle interval data type
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1232377653/0
  
• Select data into listboxes, comboboxes and other controls
  Building a user-friendly Excel Oracle front-end  
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1232273911
  

 
Release log covering versions 4.1.12 - 4.3.10: http://www.oraxcel.com/projects/sqlxl/releaselog3.html
Release log covering versions 4.0.41 - 4.1.11: http://www.oraxcel.com/projects/sqlxl/releaselog2.html
Release log covering versions 4.0.26 - 4.0.40: http://www.oraxcel.com/projects/sqlxl/releaselog1.html