Hi,
Why they are different, I do not know. Some decision made by someone
at Microsoft for some reason? You will need to convert from the variant data
types to the DAO data types. This is why I suggested using the Select Case
statement. However, I got that somewhat wrong. The top part should be:
Dim varCellValue As Variant
Dim vtType As VbVarType
' ...
varCellValue = ActiveSheet.Cells(1, c).Value
vtType = VarType(varCellValue)
Select Case vtType
You will need to fill out the internals of the Select Case statement to
do the actual conversions. Do a search in the online help for "VarType
Constants" and "DataTypeEnum" to get the listings of possible values of the
types.
Clifford Bass
