VBA Training - Excel Access Integration

Duration

1 day

Objectives

Enable delegates to start integrating Excel- and Access-based applications, using VBA:

  • Examine alternative scenarios and techniques for integration
  • Explore the ADODB VBA library
  • Introduce XML files.

Prerequisites

Delegates should have a good grounding in VBA, to the level of the introductory Excel VBA or Access VBA courses, plus some hands-on experience.

Topics

  • Introduction: Why integration?
     
  • Doing it without VBA
    • Query tables
    • Query wizard / MS Query
    • Access queries
       
  • Doing it with VBA
    • ADODB library: Connections and Recordsets
    • Table-based and Query-based Recordsets
    • Access-side Recordsets
    • Excel Range.CopyFromRecordset
    • Seek and Filter
    • QueryTable and PivotCache Recordsets
       
  • XML files
    • Export from Access
    • Import to Excel table
    • XmlMap and XMLDataBinding
[Roy MacLean - IT] [VBA Training - Introduction to VBA] [VBA Training - Excel VBA] [VBA Training - Access VBA] [VBA Training - Word VBA] [VBA Training - Advanced VBA] [VBA Training - Excel Access Integration] [MS Office Training - Excel Advanced] [DITA Training - Introduction]