<div>
In the click event of the button, add the DoCmd.Transfer????, reference your saved import spec.
</div>


In the click event of the button, add the DoCmd.Transfer????, reference your saved import spec.

<div>
use this command<br />
<br />
DoCmd.RunSavedImportExport<wbr /> &quot;Name Of SavedImportExport&quot;
</div>


use this command

DoCmd.RunSavedImportExport "Name Of SavedImportExport"

<div>
Although it seems that the RunSavedImportExport method is easier, keep in mind that you have no way to change it at run time. &nbsp;So for example, if you are doing an export and you want to include the date as part of the file name, you can't do that with RunSavedImportExport. &nbsp;You have to use the Transfer... method so you can include a different file name each time you export.<br />
<br />
Also, the RunSavedImportExport is more fragile. &nbsp;I just changed the code one of my clients wrote to use the TransferText because he doesn't have any control over the file he is receiving and the maker added two new columns. &nbsp;The TransferText method (if you are importing a .csv file) doesn't fail.
</div>


Although it seems that the RunSavedImportExport method is easier, keep in mind that you have no way to change it at run time.  So for example, if you are doing an export and you want to include the date as part of the file name, you can't do that with RunSavedImportExport.  You have to use the Transfer... method so you can include a different file name each time you export.

Also, the RunSavedImportExport is more fragile.  I just changed the code one of my clients wrote to use the TransferText because he doesn't have any control over the file he is receiving and the maker added two new columns.  The TransferText method (if you are importing a .csv file) doesn't fail.

<div>
Thank you. &nbsp;Sorry for my tardy reply....
</div>


Thank you.  Sorry for my tardy reply....

<div>
<div class="content wysiwyg-content">
Experts, how can I call up a saved import through an event on a forms button?<br />
<br />
I have to do this manually and want to assign this saved task to a button. &nbsp;<br />
<br />
thank you
</div>
</div>


Experts, how can I call up a saved import through an event on a forms button?

I have to do this manually and want to assign this saved task to a button.  

thank you

Saved Import - assign to a button

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.