<div>
Okay - i hoped for an easier solution.<br />
<br />
But I will try with some scripting...
</div>


<div>
<div class="content wysiwyg-content">
I have an Excel with ODBC connection to our SQL database.<br />
<br />
I have to update this Excel every day and send it.<br />
<br />
I want to automate this process in a bat file.<br />
<br />
<b>Is it possible to update an Excel with ODBC via a command line / parameters?</b><br />
<br />
I know, that Excel must be installed but I want to either start the bat file manually or fx schedule the bat file in my lunch break.
</div>
</div>


I have an Excel with ODBC connection to our SQL database.

I have to update this Excel every day and send it.

I want to automate this process in a bat file.

Is it possible to update an Excel with ODBC via a command line / parameters?

I know, that Excel must be installed but I want to either start the bat file manually or fx schedule the bat file in my lunch break.

Excel ODBC - update and save in Command line

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.