Solved

Excel ODBC - update and save in Command line

Posted on 2016-07-22
2
56 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 51

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

749 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