The following table lists the field data types and their equivalent Visual Basic data types.
Field data type Visual Basic data type
True/False Integer
Byte Integer
Integer Integer
Long Long
Currency Double
Single Single
Double Double
Date/Time Variant
Text String
Long Binary String or Variant; can be longer than 64K
Memo String or Variant; can be longer than 64K
Note that any kind of value can be stored in a Variant data type.