是这样的, Dim app As New Access.Application 我现在要在vb中用access 9.0 object libray的对象与方法连接access(中有两个子表),并插入数据(表的路径为m_sLocalPath) 注:要求如此,郁闷中(Excel可以,但access的我不会)
我还是引用了dao3.51
Private mobjAccess As New Access.Application
Private mobj As Object
Private Sub Form_Load()
mobjAccess.OpenCurrentDatabase App.Path & "\db1.mdb"
Set mobj = mobjAccess.DBEngine.Workspaces(0).Databases(0).OpenRecordset("select * from Expenses")
mobj.MoveFirst
Call GetRecordset(mobj)
End Sub
Private Sub GetRecordset(recExp As Recordset)
With recExp
Text1.Text = 0 + !ExpenseID
End With
End Sub
sorry, dao 还不懂,
更改一下,是要非ado的方法
我的思路是想仿照vb中对excel的操作,
比如Dim app As New Excel.Application
Dim wb As Excel.Workbook
Set wb = app.Workbooks.Open(m_sLocalPath)