In this Webinar, Dale takes us on a deep dive into the techniques for using Excel as a data source when external data can't be accessed directly. Topics covered:
00:00 — Intro
01:00 — Overview of external data access
05:39 — Setting up an Excel template file
11:38 — Setting field Data Types
36:59 — Determining how to handle subsequent data imports
59:44 — Automating Imports with bpImport
1:15:39 — Windows Task Scheduler automation
1:27:47 — Additional automation considerations
1:43:35 — Importing via Process Attachment
1:55:20 — Outro
