Excel ODBC - update and save in Command line
Posted on 2016-07-22
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.