I am trying to retrieve info about the structure of a MS-SQL Server table using the OpenSchema method. For example, having the table Cars, I want the follwing info returned:
Column DataType Length
------- -------- ------
Name varchar 50
I have used "Set RS = Con.OpenSchema(adSchemaColumns)", but this doesn't seem to offer enough info for the DataType column above - what I need it to return datatypes as you'd see in the Design Mode of the table (int, varchar, ...)
Can you guys offer me some help on this?