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