You would have to refer to the corresponding enumeration. What are you using to retrieve this?

If ADO/ADOX, the reference is at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdcstdatatypeenum.asp

>Dear Sir/Madam
>
>I have written a code in vb6 which scan all the tables and their feilds and in Access MDB File and throws output in excel sheet.
>
>Problem I am facing is that I get TableName and all feilds Name of that table with data type. But Data type is in numbers Like for text feilds it is 130. So I need to know that is their any calculation or formula involved to get these figure so that I can put it under CASE statement and while displaying that data type in Numbers I will display data type name in excel sheet.
>
>Thanks
>
>Rahul