SQL field types

[Vadim]

I created a program that run SELECT
statment for the DBase III file. Than it retreives field names and types:
sFldTypes(colIdx) = rsDBF.Fields(colIdx).Type
The field types are "200" and "5"
I'd like to know what types are they?
Is anybody may give me a link to table of all types?

 

[davidrobin]

5 adDouble Double
200 advarchar varchar

I did a search in MSDN for adDBTimeStamp. There is quite a list.

David
Visual Basic 6 Ent

 

[SonOfEmidec1100]

If you look for DataTypeEnum [ADO] in the MSDN index it will give you a table of datatypes.