Solved

Excel ODBC - update and save in Command line

Posted on 2016-07-22
2
39 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
Comment Utility
>>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
Comment Utility
Okay - i hoped for an easier solution.

But I will try with some scripting...
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

When you receive another warning that your shared drive is almost full and you have asked your users to clean out old files again and again, here is a single command that may help. This command will place all the files that have not been used rec…
I have published numerous articles here at Experts Exchange that present programs/scripts written in a language called AutoHotkey. Each of those articles has a brief paragraph describing where to download the product and how to install it. I have al…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

763 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

8 Experts available now in Live!

Get 1:1 Help Now