There was an error displaying content. Please refer to event log.
×
Register
Login
Button
Home
Contact us
Products & downloads
Excel Database Tasks (EDT)
Download EDT
Help
Excel Database Tasks
Worked examples
Loading data
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 Import Excel spreadsheet using Stored Procedure
How to connect Excel to Remote Web Server SQL Database
First Steps
Requirements
Task Files and Task Folders
Installation
EDT and AVG anti virus settings
Network Installation
Advanced techniques
Task parameters
Include task parameter in connection string
Did you know? - EDT Tips
Organising EDT task files
Where should I install EDT?
Reference
Connection strings
CSV / Text file connection strings
Excel Connection Strings
SQL
Create Insert Update Delete stored procedure
Upgrade Advice
Copyright
Command Line Interface and Task Scheduling
introduction
Importing CSV Bank Statements with SQL
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
Feedback
Help desk
View Public tickets
New ticket
Remote Assistance
Service Level Agreement (SLA)
Privacy Statement
Purchase
Purchase your EDT Licence
Purchase Analysis / Developer days
Purchase your FormSnips Intranet licence
Feedback
×
Before you go ...
Discover Lean Solutions
* required
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!
Rodney Jewer
EDT Adds Postal Metering Validation at Great Value
Lean Software’s Professional Services and EDT have literally saved us 95% in costs when compared to our mailing equipment vendors proposed validation software solution. Lean Software provided us with a turn-key solution in a very short period of time. The EDT solution has also saved us time & effort in having to develop and maintain our own in-house solution. EDT is very user friendly and easy to learn so that any of our users can pick it up in no time flat as it is fully automated and validates in real-time. EDT connects with our SQL Server to update our records as mail pieces are metered and then scanned before going out in the mail. Having this information in our database now allows us to not only validate each piece but to also report on them as required by our client. Thank you, Lean Software for a fantastic product and an excellent overall experience! Rodney Prepress Software Engineer
Ann Matti
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
Great Support
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.
Phil Donaldson
EDT
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.
Sarah Jessop
Cost saving
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
Amin Adatia
Lean Software
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.
Simon Redgrave
Lean Software
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
David McIntire
EDT feedback
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
Email:
Name:
Your Feedback
Subject:
Message Body:
Characters Remaining:
1000
Send Feedback