You can use Automation to create an instance of Excel in an Access VBA module and pass information (here the result of a query) to it. With this method you actually can do whatever you want with an Excel document from Access.
As a guideline:
Function OpenExcelDocument(ByVal DocName As String)
' You must have a reference to the Excel Object Library in your project
' (Tools --> References --> 'Microsoft Excel 11.0 Object Library' for Office 2003).
Dim appXL As Excel.Application
Set appXL = New Excel.Application
' Your code goes here
Set appXL = Nothing
The code you need to: "use the data from a query to provide the fields with data". Your original question was not precise enough to provide a more detailed answer. I guess that it should be something like:
Dim rst as DAO.Recordset
Dim fld As DAO.Field
Do Until .EOF
For Each fld In rst.Fields
' Compute the address of the Excel cell --> RowIdx, ColIdx
AppXL.ActiveWorkbook.Worksheets("Sheet1").Cells(RowIdx, ColIdx).Value = fld.Value