There are a couple of ways.
You could use MSQuery
From the menu bar
Import External Data, New Database Query
You can also use VBA to attach to an Access table. Here is an example:
Dim wrkJet As Workspace
Dim dbf As DAO.Database
Dim rst As DAO.Recordset
'Set up recordset for combo
Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet)
Set dbf = wrkJet.OpenDatabase _
("\\rsltx1-bm01\busmgmt\Dev CISCMS\ciscmsdata.mdb")
Set rst = dbf.OpenRecordset("Select * from tbllkEmployee " _
& "ORDER BY tbllkEmployee.EmployeeName;")
