<div>
I got it with:<br />
<br />
DoCmd.TransferDatabase acExport, &quot;Microsoft Access&quot;, LFilename, acQuery, &quot;qryHeaderRecordsToArchive<wbr />&quot;, &quot;tblDataHeader-&quot; &amp;&nbsp;Me.txtFileName, False<br />
<br />
<br />
But you were correct. I needed to change acTable to acQuery
</div>


<div>
<div class="content wysiwyg-content">
I'm trying to export a table to an external Access database file via VBA code. &nbsp;The code I'm trying is:<br />
<br />
DoCmd.TransferDatabase acExport, &quot;Microsoft Access&quot;, LFilename, acTable, &quot;qryHeaderRecordsToArchive<wbr />&quot;, &quot;tblDataHeader- &amp;&nbsp;Me.txtFileNameAndLocation,<wbr /> False&quot;<br />
<br />
But it isn't working. &nbsp;Note LFilename is establish with:<br />
<br />
LFilename = DLookup(&quot;[ArchiveFileLoc]&quot;<wbr />, &quot;tblSetup&quot;) &amp;&nbsp;&quot;\&quot; &amp;&nbsp;Me.txtFileNameAndLocation &amp;&nbsp;&quot;.accdb&quot;<br />
<br />
So I'm hoping to get the exported file table to be named tblDataHeader PLUS Me.txtFileName<br />
<br />
In other words tblDataHeader-something &nbsp;(something being the &nbsp;Me.txtFileNameAndLocation &nbsp;part of it.
</div>
</div>


I'm trying to export a table to an external Access database file via VBA code.  The code I'm trying is:

DoCmd.TransferDatabase acExport, "Microsoft Access", LFilename, acTable, "qryHeaderRecordsToArchive", "tblDataHeader- & Me.txtFileNameAndLocation, False"

But it isn't working.  Note LFilename is establish with:

LFilename = DLookup("[ArchiveFileLoc]", "tblSetup") & "\" & Me.txtFileNameAndLocation & ".accdb"

So I'm hoping to get the exported file table to be named tblDataHeader PLUS Me.txtFileName

In other words tblDataHeader-something  (something being the  Me.txtFileNameAndLocation  part of it.

Trying to export a table to another Access database file

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.