|
发表于 2012-6-13 19:48
|
显示全部楼层
本楼为最佳答案
本帖最后由 suye1010 于 2012-6-13 19:54 编辑
- Private Sub test()
- Dim myData As String, SQL As String
- Dim myDB As DAO.DATABASE, myRs As DAO.Recordset
- myData = ThisWorkbook.Path & "\数据库.mdb"
- On Error Resume Next
- Set myDB = OpenDatabase(myData, False, False, ";pwd=1234")
- SQL = "select Distinct [" & combo1.Text & "] from [表1]"
- Set myRs = myDB.OpenRecordset(SQL)
- Do
- Combo2.AddItem myRs.Fields(combo1.Text)
- myRs.MoveNext
- Loop While myRs.EOF = False
- End Sub
复制代码 对于正常运行的此代码,必须引用 Microsoft DAO 3.6 对象库。若要执行此操作,在 Visual Basic 编辑器中 工具 菜单上单击 引用,并确保已选中 Microsoft DAO 3.6 对象库 的复选框。
|
|