<div>
But how can i do that in just one command ? Or like a .bat ? Is that possible ? Like macro ?
</div>


But how can i do that in just one command ? Or like a .bat ? Is that possible ? Like macro ?

<div>
You could create saved queries in Access, and then create a macro that runs those queries. I don't use macros, so can't really help much with that, but it's pretty straight forward with the OpenQuery action in your macro.
</div>


You could create saved queries in Access, and then create a macro that runs those queries. I don't use macros, so can't really help much with that, but it's pretty straight forward with the OpenQuery action in your macro.

<div>
<div class="content wysiwyg-content">
How can i drop a table and insert the values from a query on it ?
</div>
</div>


How can i drop a table and insert the values from a query on it ?

Populate table using a query on access

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

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.