There's a couple of different ways to achieve what I 'think' you're trying to do.
One way I might approach this is to have the excel sheet linked into MSAccess (ie. File->Get External Data -> Link table.
This would be providing the excel sheet is a row-based record system (ie. there's not a lot of other header info, graphics, etc...) Then it would be a matter of writing a query to populate the excel sheet with the data from the MSAccess table.
Another method might be to write some vba code (there's examples in the code bank) where you populate certain cells within the excel sheet. Again, check the code bank on ways to do this.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)