Dim i As Integer
Dim RS As ADODB.Recordset
......For i = 0 To RS.Fields.Count - 1
Combo.AddItem RS.Fields(i).Name
Next i
Dim RS As ADODB.Recordset
......For i = 0 To RS.Fields.Count - 1
Combo.AddItem RS.Fields(i).Name
Next i
for i=0 to rs.fields.count-1
combo1.additem rs.fileds(i).name
next
再用循环:
For i = 0 To rs.Fields.Count - 1
COMBOX.AddItemTRIM(rs.Fields(i).Name)
NEXT I
select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='tablename'
小写的tablename写你的表名。
其中 rst 是一个 recordset
fields(i)是rst的属性
name是field的属性