<div>
<div class="content wysiwyg-content">
When I run the following code... either in a row or in 2 different spots in the code I get an &quot;Error Invalid Argument&quot; when trying to execute the second docmd.transfertext.<br />
<br />
Is there a a way to take the same data and import it into 2 different tables at the same time... or after importing copy the data from one table to the other?<br />

<pre><code id="code-36326">DoCmd.TransferText acImportDelim, &quot;Grps Import Specification&quot;, &quot;Grps&quot;, &quot;C:\Grps_&quot; &amp; Yr &amp; Mth &amp; Dy &amp; &quot;.txt&quot;
        
DoCmd.TransferText acImportDelim, &quot;Grps Import Specification&quot;, &quot;NewGrps&quot;, &quot;C:\Grps_&quot; &amp; Yr &amp; Mth &amp; Dy &amp; &quot;.txt&quot;
</code></pre>
</div>
</div>


When I run the following code... either in a row or in 2 different spots in the code I get an "Error Invalid Argument" when trying to execute the second docmd.transfertext.

Is there a a way to take the same data and import it into 2 different tables at the same time... or after importing copy the data from one table to the other?

Invalid Argument Error When Running docmd.transfertext Twice

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.