Products & downloads
Excel Database Tasks (EDT)
PERFECT PORTAL - SQL Server Integration module
P4W Conveyancing Workflows
P4W Generic Awaiting Items (GAIL)
P4W Open Hyperlink Matter Service (Ohms)
P4W Search Partner
Excel Database Tasks
How to Import Excel spreadsheet using Stored Procedure
How to Import CSV file using a Stored Procedure
How to import CSV data to SQL Server
How to Import Multiple Excel Worksheets
How to import Multiple Excel Workbooks
How to Import Excel spreadsheet to SQL Server data
How to connect Excel to Remote Web Server SQL Database
Task Files and Task Folders
EDT and AVG anti virus settings
Include task parameter in connection string
Case Study - AK Law - Goodbye Manual Processes, Hello Productivity
Did you know? - EDT Tips
Organising EDT task files
Where should I install EDT?
Command Line Interface and Task Scheduling
Task configuration tabs
Data Destination / template tab
Excel data destination connection
Select Task Method Template
Data source / SQL tab
Define data to retrieve
Maintain data source connection
Excel Connection Strings
CSV / Text file connection strings
Create Insert Update Delete stored procedure
Why Excel Database Tasks?
Partner for Windows (P4W)
Conveyance - Purchase
Perfect Portal Integration
Generic Awaiting Item Logic (GAIL)
Open Hyperlink Matter Software (OHMS)
P4W Case flow development services
Purchase your EDT Licence
Purchase Analysis / Developer days
Purchase your FormSnips Intranet licence
View Public tickets
Service Level Agreement (SLA)
Before you go ...
Discover Lean Solutions
Our team will respond and discuss a solution with you
Provide a proof of concept model or quotation
You will be surprised by the possibilities!
EDT as Integration Manager with MS SQL
We have adapted EDT as an integration manager to transfer large set of data (at least 15,000 rows in each sheet) from Excel to SQL directly. With Lean software's help, we were able to build powerful stored procedure and with aggressive multiple check points to ensure that data accuracy and deduplications are avoided when importing the data. The intuitive front end with the toolbars and color coding has made a big difference to our end users. EDT has allowed us to overcome the manual entry for thousands of records and therefore saved us tremendous amount of time to get our work done efficiently and accurately. Support is great when needed. Thanks as always to the founder of the software (he knows who he is :) ) Thanks, Ann
Doug Smith – Dir. Business Process Modeling and Integration www.commercehub.com
EDT has provided a significant productivity and quality boost for CommerceHub in maintaining its specification library.
Excel Database Tasks (EDT) is a product that allows CommerceHub to leverage the capabilities of the Excel spreadsheet tool for maintenance of specification resources stored in a relational database. The matrix framework and formula writing capabilities of Excel make it an extremely powerful data editor – often better than what can be achieved with costly, custom built maintenance applications. The barrier to using Excel as an editing environment has always been in moving data from a relational repository into an Excel spreadsheet template that includes complex formulas, and then capturing the results of an editing session back into the relational repository. EDT allows a technician to define an editing ‘task’ – a one-time effort – that that handles all of those challenges without any user intervention. The ‘task’ is then used by any number of non-technical users to perform high quality editing on relational data in an environment with which they are familiar – Excel – where all of the copy/paste and formula derivation functionality is available. The ‘task’ also performs any data integrity checks that are desired before the edited data is committed back to the relational repository. This product has provided a significant productivity and quality boost for CommerceHub in maintaining its specification library. Doug Smith – Dir. Business Process Modeling and Integration www.commercehub.com
Jonathan Pupius, Executive Manager at John Gaunt & Partners www.john-gaunt.co.uk
EDT - useful piece of software
We have been using EDT for sometime. Lean Software is excellent at providing support and developing the software as new opportunities become apparent. It is nice to use a piece of software that is updated so frequently. Jon www.john-gaunt.co.uk
Kris Hampel, Project manager, VPN Solutions Ltd www.vpnsolutions.com.au
Our requirement was to import an existing set of company records (an Excel worksheet of ~4000 rows and ~200 columns) into a relational structure in SQL Server 2012. The detailed written directions and screenshots that Lean Software has provided to me whilst developing this system have been invaluable in showing how to utilise EDT for this task. Lean Software have gone a bit beyond the call of duty frankly, having created examples of SQL stored procedures specifically for our situation based on data sets I provided, as well as creating a series of EDT Tasks demonstrating how to utilise the stored procedure for initial uploading and for data maintenance. Several new builds of EDT have been needed in order to address minor bugs that were found in the process, all of which were resolved quickly and without drama. The timely responses and general support that has been provided by Lean Software have been second to none.
I was looking for a solution for an actuary who does alot of data processing in Excel. EDT has proved to be a great tool to import the Excel data into SQL server One of the many features I found useful is the ability to specify Excel formula (R1C1 style) for the columns which has saved me days of development work! The on-line help is very good but I've also contacted Lean on a few occasions now and their help/assistance has been 1st class. Great product which will no doubt come in handy for other development work in the future.
Thanks for the feedback invitation. I can tell you that EDT has saved us in excess of $50k this year - that we would otherwise have had to pay for UI development. Next year we expect to save the same again! Funny how we expect intranet technology to be the solution for data handling - but here we have a solution that requires comparatively little development effort. The software is fast - with no web server or web browser technology in the way. Love it! Sarah Jessop Project Manager
I was comparing this to Oracle SQL Developer or Toad for Lookup Table Maintenance and having to write a User Interface to do the same. Support from Lean Software was excellent I am not sure If I get any thing better from Lean Software compared to the other two products; but beats having to develop a UI for each Table.
I agree with the comments below, it did take us some time to realise what could be achieved with EDT & the Lean Support guys helped us greatly. We sent in some project details to Lean and received task examples and were provided with stored procedures providing the solution to our quite complex requirements. Likewise our data maintenance is now efficient, and Excel data import is now problem free, saving us many hours of work. Thanks again for all the support we have received. Simon
As you know we have replaced quite a number of in-house systems with EDT. Once becoming familiar with the software and it's capabilities we are now able to build new data maintenance screens in minutes. As well as massively reduced development times, another big plus for us is that our end users are far more efficient and are able to deal with considerable volumes of data, something that I have not seen in any other software product. Previously we used intranet forms for trying to manage data, but they were slow and did not provide anything like the operator performance and data load speeds now provided by EDT. Great stuff Lean Software ! David McIntire
Your Contact Information