Ms Access Data Types

[AFish]

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?

[RealisticGraphics]

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

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.