Skip to Navigation | Skip to Content

Devcenter

Overview

MiniTutorial - Connect to Databases

In this MiniTutorial, you will learn how to connect to a database using the ODBC primitive module as well as VBA. This tutorial has taken most people between 15 - 45 minutes to complete.

MiniTutorial - Connect to Databases (PDF)

Download the MiniTutorial PDF.

MiniTutorial - Connect to Databases (ZIP)

Download a ZIP of the MiniTutorial resource files.

This MiniTutorial uses the Northwind Traders Sample Database, which is available for download from Microsoft.

You will also need to download and unzip the most recent copy of the Getting Started Components.

MiniTutorial Overview

In this MiniTutorial, you will learn how to connect to databases using the ODBC primitive module and VBA. You will:
  • Learn about the ODBC module to read data from ODBC data sources.
  • Learn about basic Components that use VBA to read from and write to databases.
  • Examine the VBA scripts to learn how to apply them in new ways on your own.