ExcelDBTools tutorial videos

Introduction to Excel DBTools video - a better VLOOKUP



Excel Example 1 - creating a simple Excel function

Excel Example 2 - retrieve multiple values


Access Example for ExcelDBtools - creating an Access Function

Create a connection to excel

Create a connection to Sql Server

Creating a custom Excel Function with ExcelDBTools

Editing a Custom Excel Function with ExcelDBTools

Editing a Custom Excel Function with ExcelDBTools (focus on Databases)