Excel Database Tasks (EDT) Download

Excel Database Tasks V5.x (Production)


Version 5.1.4  ,15th FEB 2019 
For Microsoft Excel 2007, 2010, 2013, 2016 - 32Bit or 64Bit

Manual or Network Install (ZIP file) :



EDT 5.1 New Features

  • New feature - Task Parameter File Selection - Lookup Columns now have a new option - Filename List :

When the task loads the file list is displayed in a drop down selection:

The Filename parameter can be used in the data source SQL:

EDT 5.0 New Features

Version 5 is all about performance improvements, however there are also some new features resulting from client requests.

  • 30 to 40% performance improvement - when comparing to EDT V4.0.200 (dependent on task complexity and use of SQL lookups)
  • New Immediate Send option, useful for data edit type tasks where row edits are immediately sent to the database, rather having to click Validate then Send.
  • New feature - Global Parameters - new merge parameters that can be included in any SQL or Connection string.  Example uses might be an entire connection string, a server name, a folder path or any common string you wish to use across multiple tasks, making global changes an easier maintenance task.

Global Parameters are accessed from the EDT Global Settings ribbon icon:

Global Parameters can be used anywhere where the insert parameter icon ( ) is available, such as Connection strings, any SQL and even column format hyperlinks.

You could have an entire connection string as a parameter or just portions of it – a server name for example.

The insert merge code code dialogue has a new drop down – Global Parameter


Global merge codes have the format {XL-MergeGlobal:VariableName}.


  • New system option - Disable online licence check, to support systems where an internet connection is not available or is intermittent.


EDT 5.x Release history

EDT 5.1.4 15/02/2019 When scheduling EDT tasks (using the included utility EDTCmdLine.exe), passing filename parameters containing spaces would fail.

EDT 5.1.3 13/02/2019 Message 'Could not parse SQL' resolved when using the 5.1 file list feature.

EDT 5.1.2 8/02/2019 New feature added Task Parameter file selection from a folder, with file extension matching.  Please see screen shot above.

EDT 5.0.125 4/01/2019 Special Merge code '{XL-Merge:EDT_Mode}' sometimes used by custom stored procedures was not being set correctly. Affecting Version 5 only. 

EDT 5.0.124 14/12/2018 New Freeze panes default setting added to task Interface settings. On some machines freeze panes interfered with task layout. This settings allows freeze panes to be disabled at task level.

EDT 5.0.122 12/12/2018 Client report of column misalignment when switching tasks, release to test a possible fix

EDT 5.0.121 05/12/2018 Validation error when Immediate Validation not used in Task design

EDT 5.0.120 03/12/2018 Lookup column functionality - initial lookup on data load was only working for User type columns

EDT 5.0.116 26/11/2018 New task option (Interface options) Confirm Change task when incomplete.  By default when switching to a different task EDT will prompt for confirmation if there are unsaved changes.  Un-checking this task level option will suppress this prompt.

EDT 5.0.115 22/11/2018 Excessive delay when modifying a task resolved.  Maximise window by default on Task Modify.

EDT 5.0.114 22/11/2018 Error message resolved : Error 9 [Subscript out of range] Line: 50 in procedure GatherRowValues of Module modEDT_GlobalMethods.

EDT 5.0.113 21/11/2018 Amendments Global Parameters functionality.

EDT 5.0.109 14/11/2018 Initial V5 release.

Excel Database Tasks V4.x [Production]


Excel Database Tasks V3.3.x [Professional Edition]


Excel Database Tasks V3.2.x [Professional Edition]


Excel Database Tasks V3.1 [Professional Edition]


Excel Database Tasks V2.9.3xx [Advanced Schema Edition]


Excel Database Tasks V2.9 [Network Edition]


Excel Database Tasks V2.8 [Network Edition]


Excel Database Tasks V2.7


Excel Database Tasks V2.5


Excel Database Tasks V2.4


Excel Database Tasks V2.3


Excel Database Tasks V2


Excel Database Tasks V1