In the following example, VBScript is used to link to an existing database table to correct data. First, a connection to a data table of month names is opened. VBScript determines whether the month is numeric or alphabetical, and then queries the database for the name of the month.
This VBScript example assumes that Microsoft Data Access Components (MDAC) is installed.
' Acquire Connection