open Access from Excel

[ishi]

Does anyone know how i can open an access database from excel.

thanks,

ishi

[TommyGun]

Define "open"...

[Mudface]

Try this-

Public Sub OpenAccess()
Dim appAccess As New Access.Application

Set appAccess = Access.Application
appAccess.OpenCurrentDatabase "C:\db1.mdb"

End Sub

You will need to change the path of the database to suit and also set a reference to Microsoft Access x.0 (where x is your version number) via Tools-References in the VBA editor.

[ishi]

Thanks mudface that's what i wanted but it opened it and disappeared. Had to put this line is appAccess.Visible = True to keep it open.

Tommygun i mean to launch an access database from a specific location. Then use the database as you would any access database.

Thanks again guys,

ishi