Question

vb SQL 怎么读取表的列名

vb SQL 怎么读取表的列名???

若以下回答无法解决问题，邀请你更新回答

Answer 1

sp_columns Table
======================================
第四列就是列名,也可以通过查询获得
======================================
dim AdoConn As New ADODB.Connection
dim rs As new ADODB.Recordset
dim SqlString as string
String ="Select top 1 * from Table"
Set rs = AdoConn.Execute(SqlString)
if not rs.EOF
For i = 1 To rs.Fields.Count
debug.print rs(i - 1).Name
next i
end if
Set rs=nothing
AdoConn.Close