How to Get Table Column Names 2

[EricsonJ]

I want to get the column names of a table, and I think I should use SQLColumns, but, after I consult the ODBC API reference, I was confused by those parameters.
Any one can help?

Thanks a lot

 

[CajunCenturion]

The columns names are readily available by looping thru the Fields object collection in an ADO recordset.

RecSet.Fields.Item.Name

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[teh215]

I think that you will need to look at ADOX for that.


Rob

 

[RonVaught]

You could use also an ADO Connection object’s (OpenSchema) Method. It can return all sorts of information about the data source / database. Including field / table names

 

[EricsonJ]

I have used both OpenSchema Method and RecSet.Fields.Item.Name, and it works. Thank you very much.

 

[a3b2c1r46]

Great Job guys. The RecSet.Fields.Item.Name worked for me as well. Much apperciated.