<div>
<div class="content wysiwyg-content">
If a user has MS Excel 2010 I want to be able to transfer a MS Access query to MS Excel 2010. &nbsp;If the user though has MS Excel 2003 I want the MS Access query to export to a MS Excel type of 2003. &nbsp;What are your suggestion when exporting MS Access data to MS Excel when the users may have various versions of MS Excel ?
</div>
</div>


If a user has MS Excel 2010 I want to be able to transfer a MS Access query to MS Excel 2010.  If the user though has MS Excel 2003 I want the MS Access query to export to a MS Excel type of 2003.  What are your suggestion when exporting MS Access data to MS Excel when the users may have various versions of MS Excel ?

MS Access DoCmd.TransferSpreadsheet - Export in 2003 or 2010

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.