Ms Access Data Types

Hi Guys,

How can a get the data types for fields in a MS Access database.
I need to know what data type the field acceppts,so there is'nt any Type Mismatch errors when inserting.

Any Suggestions?

Assuming you already have the recordset using ADO, you can get the field type like this:

VB Code:

Dim Fld As ADODB.Field
 
For Each Fld In rs.Fields
    debug.print Fld.Type
Next

Keep in mind that this returns an integer value corresponding to a constant in the DataTypeEnum.