Excel ODBC - update and save in Command line

Vinum
Vinum used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Team Lead
Commented:
>>Is it possible to update an Excel with ODBC via a command line / parameters?
yes, that's possible. but what stuffs are you going to "update" in your excel? to automate the process, you can write a vbscript/macro and then let relevant scripts (command line / scheduled task etc) to call it.

Author

Commented:
Okay - i hoped for an easier solution.

But I will try with some scripting...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial