Solved

Excel ODBC - update and save in Command line

Posted on 2016-07-22
2
47 Views
Last Modified: 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.
0
Comment
Question by:Vinum
2 Comments
 
LVL 49

Accepted Solution

by:
Ryan Chong earned 500 total points
ID: 41724418
>>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.
0
 

Author Closing Comment

by:Vinum
ID: 41724519
Okay - i hoped for an easier solution.

But I will try with some scripting...
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article was inspired by a question here at Experts Exchange (http://www.experts-exchange.com/Software/Photos_Graphics/Images_and_Photos/Q_28629170.html). The requirements stated in that question are (1) reduce the file size of a large number of…
Introduction: Recently, I got a requirement to zip all files individually with batch file script in Windows OS. I don't know much about scripting, but I searched Google and found a lot of examples and websites to complete my task. Finally, I was ab…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now