<div>
The transfer spreadsheet command itself gives you no control over the formatting.<br />
<br />
You can use Excel Automation (VBA) to format Excel sheets after running Transfer Spreadsheet... or even use automation for the whole thing - Export and formatting.<br />
<br />
The upside is that it is essentially opening Excel from Access, giving you all of the bells and whistles that Excel offers through programming. &nbsp;The downside is that it can be very code intensive, with a significant learning curve.
</div>


The transfer spreadsheet command itself gives you no control over the formatting.

You can use Excel Automation (VBA) to format Excel sheets after running Transfer Spreadsheet... or even use automation for the whole thing - Export and formatting.

The upside is that it is essentially opening Excel from Access, giving you all of the bells and whistles that Excel offers through programming.  The downside is that it can be very code intensive, with a significant learning curve.

<div>
<div class="content wysiwyg-content">
I am using TransferSpreadsheet in Access 2010 to export data from a pass through query to an Excel worksheet which has been preformatted with specific colors, column sizes, etc. &nbsp;This usually works fine but sometimes the formatting is not preserved. &nbsp;Is there anything I can do to guarantee that the formatting will not be changed?<br />
<br />
Note: &nbsp;I use vba code which always runs the TransferSpreadsheet the exact same way, exporting to the same target worksheet and the same range name.
</div>
</div>


I am using TransferSpreadsheet in Access 2010 to export data from a pass through query to an Excel worksheet which has been preformatted with specific colors, column sizes, etc.  This usually works fine but sometimes the formatting is not preserved.  Is there anything I can do to guarantee that the formatting will not be changed?

Note:  I use vba code which always runs the TransferSpreadsheet the exact same way, exporting to the same target worksheet and the same range name.

Formatting lost when exporting from Access to Excel template

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.