Data Types - Names

I use the ODBC method GetTableSchema (GetSchemaTable??? ...) to get the schema
for the specified table. I have two fields in this table that I need a little
help with.

First table is DataType which maps to the underlying system datatype. How can I
convert this to a string to store in a variable?

Next is ProviderType which is dependant on the provider. As of now, I only use
two different providers, SQL Server and MSAccess. ProviderType field returns a
number which needs to be converted to the name of the datatype the number
represents. If possible, I would like to convert for any provider listed, but
SQL Server and MSAccess are the two most important if the rest can't be done at
the same time.

Thanks in advance!

Mythran