<div>
You can use the TransferSpreadsheet function in a Macro.<br />
<br />
Create a macro and select TransferSpreadsheet,<br />
Choose your table,<br />
Set the Actions for the TransferSpreadsheet and in the Range set it to A3:F3,<br />
Run the Macro and the required cells will be populated.
</div>


You can use the TransferSpreadsheet function in a Macro.

Create a macro and select TransferSpreadsheet,
Choose your table,
Set the Actions for the TransferSpreadsheet and in the Range set it to A3:F3,
Run the Macro and the required cells will be populated.

<div>
Thanks. Exactly what i was looking for.<br />
<br />
Regards,<br />
<br />
Charley
</div>


Thanks. Exactly what i was looking for.

Regards,

Charley

<div>
<div class="content wysiwyg-content">
How can i export an Access query to a predefined excel file layout ?<br />
<br />
My query named Salary have the following fields.<br />
<br />
BranchCode<br />
Employee<br />
Salary Date<br />
PostCurrency<br />
PostAmount<br />
Narration<br />
<br />
How can i export the contents of this query into an Excel File C:\ TEST.XLS having sheet &nbsp;named &quot;Salary&quot;, starting From A3:F3?<br />
<br />
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.<br />
<br />
I have hundreads of records in query.<br />
<br />
Regards,<br />
<br />
Charley<br />
<br />
<br />

</div>
</div>


How can i export an Access query to a predefined excel file layout ?

My query named Salary have the following fields.

BranchCode
Employee
Salary Date
PostCurrency
PostAmount
Narration

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.

Regards,

Charley




export an Access query to a predefined excel file layout

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.