Get Column data type

[pelagic]

Hi there,
Hi there,

I have the following tableA with data
Column1 Column2 Column3
99 You Me
100 Me You

How do I get the column data type in tableA using VB
In this case
Column1 is integer
Column2 and 3 are string

Is there a function that display Column data type?

Thank you

 

[gmmastros]

What database are you using?

If it's SQL Server, then you can run this query:
Select * From Information_Schema.Columns Where Table_Name='[!]MyTableName[/!]'



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[pelagic]

Hi Gmmastros,

I am using MS Access database.

thanks,
pelagic

 

[gmmastros]

I assume you are using ADO to connect to the access database. You could try...

msgbox TypeName(Rs.Fields.Item("[!]ColumnName[/!]").Value)


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom