To access another Office application from Excel, it requires to have a basic knowledge of the other application (Word, Access, Powerpoint, Outlook)objects, methods and properties. There are many sites explaining object models in MS Office, only time to have to spend.
With regard to what you need specifically to do, I would suggest to implement one Excel macro from where to access MS Access. Take it as an example that could open the road for your specific tasks to be performed:
Option Explicit
Dim appACC As Access.Application
Sub XLAccess()
Set appACC = CreateObject("Access.Application")
With appACC
.OpenCurrentDatabase "D:db2.mdb"
.DoCmd.TransferSpreadsheet _
acImport, _
acSpreadsheetTypeExcel9, _
"tblEmployee", _
"D:Employee.xls", _
True, _
"A1:D3"
.DoCmd.TransferSpreadsheet _
acExport, _
acSpreadsheetTypeExcel9, _
"tblEmployee", _
"D:Employee.xls", _
True
.CloseCurrentDatabase
End With
Set appACC = Nothing
End Sub
Make use of Access VBE Help menu to get specific information about DoCmd object and TransferSpreadsheet method. In order to use the same workbook for both import and export and data, I assume that you have at least Excel 97, otherwise you are going to overwrite the data you imported in the first instance, when you proceed to the export of the query data from Access to Excel.