Register
Login
Button
Home
Contact us
Products & downloads
Excel Database Tasks (EDT)
Download EDT
P4W Conveyancing Workflows
P4W Generic Awaiting Items (GAIL)
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
Partner for Windows (P4W)
Conveyancing Workflows
Training
Conveyance - Purchase
EDT integration
Generic Awaiting Item Logic (GAIL)
Introduction
P4W Case flow development services
Feedback
Help desk
View Public tickets
New ticket
Remote Assistance
Service Level Agreement (SLA)
Purchase
Purchase your EDT Licence
Purchase Analysis / Developer days
Purchase your FormSnips Intranet licence
Help desk
×
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!
New Ticket
Existing and Public Tickets
Reset Search
Ticket # or Search Text:
*All*
New
Active
On Hold
Resolved
Cancelled
*All*
Normal
High
Low
*All*
Unassigned
TaskID
Status
Priority
Due
Created
Assigned
Description
Requestor
App Version
Public/Private
409
Resolved
Normal
8/6/2015
Unassigned
Formula on Excel Validation
Latest Comment:
Advised client by email, awaiting response on resolved status.
Invesco Houston USA
EDT 3.x
Public
373
Resolved
Normal
10/8/2014
Unassigned
Prob w/formula that references SQL lookup cell
Latest Comment:
In our tests the work column updates ok when changing the dropdown. Could you try using column reference rather than RC[1], so this would be J1 if the ...
CommerceHub
EDT 3.x
Public
372
Resolved
Normal
10/1/2014
Unassigned
Query Designer in Task Parameter Lookup Column
Latest Comment:
Sorry Andrew, we updated the wrong ticket.
Andrew Miller
EDT 3.x
Public
220
Resolved
Normal
12/10/2012
Unassigned
Task Configuration losing track of table name
Latest Comment:
Problem is fixed in version 2.8.870! I'd be curious to know what the root cause turned out to be, but this ticket can finally be closed! ...
CommerceHub
EDT 2.x
Public
Page Size:
5
10
25
50
75
100
300
500
1000
Search Tags:
Skip Navigation Links.
Bug report
Consultancy
Database
Feature request
Feedback
Help request
Search Tags:Skip Navigation Links.