The variant type is a special type that can contain values of the following types:
The variant type is the type of the
field property of
recordset objects, and is only used when accessing
values from recordset fields (which can have a variety of types). Variant values
are automatically converted to appropriate types, whenever they are used in expressions. So
you can't use this type to declare variables or parameters.
The idea behind the variant type is to make database handling more robust, by
isolating programs to some extent from the specific type of the fields in databases.