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
New Ticket
Existing and Public Tickets
Ticket:
598
Created:
9/5/2018 7:51 PM
Public/Private:
Public
Private
Status:
New
Active
On Hold
Resolved
Cancelled
Feature request accepted
Assigned:
Unassigned
Lean Application / Version:
EDT 5.1.130
EDT 5.1.15
EDT 5.1.14
EDT 5.1.10
EDT 5.1.9
EDT 5.1.8
EDT 5.1.4
EDT 5.1.3
EDT 5.1.2
EDT 5.0.129
EDT 5.0.128
EDT 5.0.127
EDT 5.0.125
EDT 5.0.124
EDT 5.0.123
EDT 5.0.122
EDT 5.0.121
EDT 5.0.120
EDT 5.0.119
EDT 5.0.118
EDT 5.0.116
EDT 5.0.115
EDT 5.0.114
EDT 5.0.113
EDT 5.0.109
EDT 5.0.106
EDT 4.0.238
EDT 4.0.233
EDT 4.0.232
EDT 4.0.226
EDT 4.0.221
EDT 4.0.220
EDT 4.0.207
EDT 4.0.206
EDT 4.0.205
EDT 4.0.200
EDT 4.0.199
EDT 4.0.198
EDT 4.0.197
EDT 4.0.194
EDT 3.x
EDT 4.x
P4W Purchase 1.x
P4W Sale 1.x
P4W Remortgage 1.x
Perfect Portal 1.x
EDT 2.x
P4W Purchase 1.1
P4W Purchase 1.2
P4W Purchase 1.3
Lean Website x
Priority:
Normal
High
Low
Due Date:
Name:
Jim Kientzy
Email:
-
Phone:
Estimate Hours:
Description:
Start:
Complete:
Comment
User
Time
Select
Issue resolved for client - an unusual error but now sorted. New version of EDT released. Thanks Jim for helping us sort this for you.
Lean Software
9/7/2018 8:59:58 PM
Select
Error report : EDT Version 4.0.205 Have a Trial version Set up Destination to Microsoft SQL Set up Source as Excel CSV I want to Map Source to Destination Columns The "Map Column" button is grayed out. The same for the "Report Column" Please let me know what I can do to fix this. thanks Thank you System message: Error 402 [Must close or hide topmost modal form first] Line: 80 in procedure cmdCancel_Click of Form frmConfig Technical information: 9/5/2018 12:45:10 PMcboConfig_Change->Config-><
Config->frmConfig_UserForm_Activate-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config-><
Config->frmConfig_UserForm_Activate-><
Config->frmConfig_UserForm_Activate->DisplayAccessRestrictons-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate-><
Config->frmConfig_UserForm_Activate->GetFormatFromRange-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate-><
Config->frmConfig_UserForm_Activate->GetFormatFromRange-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate-><
Config->frmConfig_UserForm_Activate->GetFormatFromRange-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate-><
Config->frmConfig_UserForm_Activate->Layout-><
Config->frmConfig_UserForm_Activate->Layout->GoHome-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate->Layout-><
Config->frmConfig_UserForm_Activate->Layout->TrafficLights-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate->Layout-><
Config->frmConfig_UserForm_Activate->Layout->PositionButtons-><
Config->frmConfig_UserForm_Activate->Layout->PositionButtons->FontIsInstalled-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate->Layout->PositionButtons-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate->Layout-><
Config->frmConfig_UserForm_Activate->Layout->FormatWithTheme-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate->Layout-><
Config->frmConfig_UserForm_Activate->Layout->HideButtons-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate->Layout-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate-><
Config->frmConfig_UserForm_Activate->CloneFormat-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate-><
Config->frmConfig_UserForm_Activate->CloneFormat-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate-><
Config->frmConfig_UserForm_Activate->CloneFormat-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate-><
Config->frmConfig_UserForm_Activate->CloneFormat-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate-><
Config->frmConfig_UserForm_Activate->CloneFormat-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate-><
Config->frmConfig_UserForm_Activate->CloneFormat-> 2562 9/5/2018 12:45:10 PMcboConfig_Change->Config->frmConfig_UserForm_Activate-> 2562 9/5/2018 12:45:06 PMcboConfig_Change->Config-> 2558 9/5/2018 12:45:06 PMcboConfig_Change-><
frmConfig.Inititialise-><
Requestor
9/5/2018 7:51:23 PM
Tags:
Skip Navigation Links.
Bug report
Consultancy
Database
Feature request
Feedback
Help request