Linking Access Dbase Records to Excel Spreadsheet

[Guest]

Can one link/hyperlink Access dbase records to an excel file?"

 

[Guest]

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;")