<div>
try <a href="https://docs.microsoft.com/en-us/office/vba/api/access.docmd.transferdatabase" rel="ugc">this</a><blockquote>To run the <strong>ImportExportData</strong> action in a Visual Basic for Applications (VBA) module, use the <strong>TransferDatabase</strong> method of the <strong>DoCmd</strong> object.</blockquote><pre><code class="code-1 nolinks" id="code-20-43312798-1">DoCmd.TransferDatabase acImport, "Microsoft Access", _ 
&nbsp; &nbsp; "C:\Users\Public\Northwind.accdb", acReport, "Monthly Sales Report", _ 
&nbsp; &nbsp; "Corporate Sales Report"</code></pre><blockquote>&nbsp;</blockquote><br><br>
</div>


try this [https://docs.microsoft.com/en-us/office/vba/api/access.docmd.transferdatabase]

> To run the ImportExportData action in a Visual Basic for Applications (VBA) module, use the TransferDatabase method of the DoCmd object.

DoCmd.TransferDatabase acImport, "Microsoft Access", _ 
    "C:\Users\Public\Northwind.accdb", acReport, "Monthly Sales Report", _ 
    "Corporate Sales Report"

>  



Developer

Murray Brown

<div>
<div class="content wysiwyg-content fr-view">
Hi<br><br>I have an Access database called "Source Data.accde" that is on my client's computer. I want to send them a database called "New Tables.accdb" that has a single form with a button that on click calls VBA code that pushes these tables to the "Source Data.accde" database, which is in the same folder.<br>The reason I am doing this is because the client is confused about how to import tables. How would I do this?<br><br>Thanks
</div>
</div>



Hi
I have an Access database called "Source Data.accde" that is on my client's computer. I want to send them a database called "New Tables.accdb" that has a single form with a button that on click calls VBA code that pushes these tables to the "Source Data.accde" database, which is in the same folder.
The reason I am doing this is because the client is confused about how to import tables. How would I do this?
Thanks

Access VBA - Copy tables to another database in same table

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.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.