Lean Software Ltd > Help > Excel Database Tasks > Reference

Click to Discover a better way to handle batch data - the EDT software..

No part of this publication may be reproduced, transmitted, transcribed, stored in a retrieval system, or translated into any language, in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without prior written permission from Lean Software Ltd. The information furnished herein is believed to be accurate and reliable. However, no responsibility is assumed by Lean Software Ltd. For its use, or for any infringements of patents or other rights of third parties resulting from its use.

Excel Database Tasks (EDT) is a trademark of Lean Software Ltd
Excel is the trademark of Microsoft
Partner for Windows is a Trademark of Tikit.

Worked examples
- Loading data
- How to connect Excel to Remote Web Server SQL Database
First Steps
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
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