<div>
Ok, that sounds good. I'll try that, thank you very much for your help.<br />

</div>


Ok, that sounds good. I'll try that, thank you very much for your help.


<div>
It worked, that's great. Thanks.
</div>


<div>
<div class="content wysiwyg-content">
From an an Access Macro you can execute a DoCmd.TransferDatabase command, which will copy a table including indexes and everything from one database to another. <br />
<br />
How can I call a DoCmd using VB.NET?<br />
<br />
Here is the syntax, as found in the Access help:<br />
DoCmd.TransferDatabase acImport, &quot;Microsoft Access&quot;, _<br />
&nbsp; &nbsp; &quot;C:\My Documents\NWSales.mdb&quot;, acReport, &quot;NW Sales for April&quot;, _<br />
&nbsp; &nbsp; &quot;Corporate Sales for April&quot;<br />
<br />
I tried using an OledbCommand.ExecuteNonQue<wbr />ry, but that did not work.<br />
<br />
thx,<br />
<br />
-brokeMyLegBiking<br />
<br />

</div>
</div>


From an an Access Macro you can execute a DoCmd.TransferDatabase command, which will copy a table including indexes and everything from one database to another. 

How can I call a DoCmd using VB.NET?

Here is the syntax, as found in the Access help:
DoCmd.TransferDatabase acImport, "Microsoft Access", _
    "C:\My Documents\NWSales.mdb", acReport, "NW Sales for April", _
    "Corporate Sales for April"

I tried using an OledbCommand.ExecuteNonQuery, but that did not work.

thx,

-brokeMyLegBiking



Execute a DoCmd.TransferDatabase in MS Access using VB.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,