Open Access db with excel VBA

[oravec]

Hello,

How do you open an Access db from within Excel VBA? The db uses Access97.

Thanks,
Cliff

 

[Mudface]

In the Excel VB editor, set a reference (through Tools- References) to the Microsoft Access 8.0 Object Library. Then use the following code, changing the path to your database as appropriate-

Dim db As Access.Application
Public Sub OpenDB()

Set db = New Access.Application
db.OpenCurrentDatabase "C:\My Documents\db2.mdb"
db.Application.Visible = True

End Sub

 

[oravec]

Thank you,

That gets me off to a good start. I will have more questions as I try to figure out what to do next.

Cliff