what is the yes/no type to be defined in code

[syedshaffee]

Hey,People
I have a code for checking Type of data that is been uploaded from excel to my database.

Private Function GetDBDataTypePrefix(ByVal fldDBData As Variant) As String
    Select Case fldDBData.Type
        Case dbDate, dbTime, dbTimeStamp        ', adDate, adDBDate, adDBTime, adDBTimeStamp
            GetDBDataTypePrefix = g_sDBDateChr
        Case dbChar, dbText, dbMemo             ', adWChar, adVarWChar, adVarChar, adLongVarWChar, adLongVarChar, adBSTR
            GetDBDataTypePrefix = "'"
    End Select
End Function

Here is the code for checking which Type of data is been uploaded in my Table so now i want to known the type of yes/no.Eg dbyes/no or adYes/no

Please help

[zmbd]

yes/no table fields are boolean... thus, should be dbboolean

http://allenbrowne.com/ser-49.html

[syedshaffee]

Thanks zmbd thanx a lot