<div>
Thank you both,<br />
<br />
The solution of Mbizup works even if the format is rather poor.<br />
But a macro can very ease solve the format problem.<br />
Also is good to know that it is recommended that the source data be exported, not the report.<br />
Thanks again,
</div>


Thank you both,

The solution of Mbizup works even if the format is rather poor.
But a macro can very ease solve the format problem.
Also is good to know that it is recommended that the source data be exported, not the report.
Thanks again,

<div>
<div class="content wysiwyg-content">
Hi guys,<br />
<br />
I have to export a report from Access to Excel.<br />
The problem is that I get a report in Excel where the order of the fields is different in comparison with the order of the fields in the Access report.<br />
What do I have to do the get the same order of the fields in the both reports?<br />
Thank you
</div>
</div>


Hi guys,

I have to export a report from Access to Excel.
The problem is that I get a report in Excel where the order of the fields is different in comparison with the order of the fields in the Access report.
What do I have to do the get the same order of the fields in the both reports?
Thank you

Export a report from access 2003 to excel

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.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.