export an Access query to a predefined excel file layout
Posted on 2004-03-30
How can i export an Access query to a predefined excel file layout ?
My query named Salary have the following fields.
How can i export the contents of this query into an Excel File C:\ TEST.XLS having sheet named "Salary", starting From A3:F3?
ie Branch code value goes into A3, Employee value into B3, Salary Date into C3, PostCurrency into D3, PostAmount into E3 and Narration into F3.
I have hundreads of records in query.