Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Excel Database Tasks Expand / Collapse
Posted Monday, January 7, 2013 7:40 AM

SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 4:56 AM
Points: 225, Visits: 646

just thought I would post an update on EDT - Excel Database Tasks.

After so many hours of development Version 2.3 now features:

> Data load, validate and and transfer from any data source - to table or Stored Procedure

> Data edit/insert tasks - based on primary key

> Task parameters

> Automatic data type validation

> Custom client validation using Excel validation

> Auto transaction wrapping

> Custom SQL with field/task parameter merge code system

> Pre & Post SQL

> Each Task configuration is saved to an XML file, and can be shared on a network

> Task configuration files are protected with encryption

Data Edit example:

You might like to check out my blog to see details of the new release:

Thanks for all of the interest


C# Gnu

Multi user data edit / data transfer Excel Task based solution
Version 2.7 released June 2013
Post #1403610
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse