Excel Database Tasks

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Excel Database Tasks

Excel Database Tasks

Rate Topic

Display Mode

Topic Options

Author

Message

C# Gnu

Posted Monday, January 07, 2013 7:40 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 3:35 AM
Points: 224, Visits: 629

Hi,

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:

http://leansoftware.net/en-us/blog.aspx

Thanks for all of the interest

Richard

C# Gnu
____________________________________________________

Excel Database Tasks V2 ..
Multi user data edit Task based solution - Excel with SQL Server / Access / MySQL ..

Version 2.5 released - See Blog

Post #1403610

« Prev Topic | Next Topic »

Permissions