The following will return the data type of your fields...
RS.Fields(icounter).Type RS is the RecordSet and icounter is the Field number.