<div>
<div class="content wysiwyg-content">
See attached code which generates a spreadsheet.<br />
<br />
How do I add the date and time to the exported file name.<br />
E.g. AccessDatabaseSalesExport_<wbr />3112112308<wbr />59&quot; or similar.<br />
<br />
<br />
I tried a few things and failed!<br />

<pre><code id="code-8242883">DoCmd.TransferSpreadsheet acExport, 10, &quot;qryExportTemp&quot;, &quot;&quot; , True, shtName</code></pre>
</div>
</div>


See attached code which generates a spreadsheet.

How do I add the date and time to the exported file name.
E.g. AccessDatabaseSalesExport_311211230859" or similar.


I tried a few things and failed!

Quickie !  Adding Date/Time onto Excel sheet exported from Access

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.