How to output XML from a regular SQL query?

What is the best scripting language to take the output from a sql query and append to an existing excel workbook?

I am new to scripting, and would like some advice. I have several different hive.ql queries that I run daily, taking the output and adding it to some excel reports I have put together to analyze the data. I have written a bash script that automagically updates the date ranges in each respective query, and kicks them off for me so I don't have to run each one manually. This saves me a good chunk of time. However, I would really like to be able to write a script that will take the output of each query, and append it to the corresponding excel worksheet so I don't have to manually copy and paste the data. I know this can be done in several languages, but because I am new to scripting, I would prefer to do it in a language that is also a good scripting language to learn in terms of future utility. Any help is greatly appreciated!
Answer:

You must be signed in to read this answer.Connected to GoogleConnected to FacebookBy continuing you indicate that you have read and agree to the . Loading account...Complete Your ProfileFull NameChecking...EmailChecking...PasswordChecking...By creating an account you indicate that you have read and agree to the .

Dinesh Tahiliani at Quora Visit the source

Was this solution helpful to you?

Other answers

I haven't done it for a while but I think the simplest by far would be to script it in the spreadsheet using Visual Basic and an ODBC connection.

Peter de Vroede

Related Q & A:

How to convert a SQL query into hibernate criteria?Best solution by Stack Overflow
What is the best cold climate area to visit to have a great time?Best solution by Yahoo! Answers
What is the best way to get rid of nerves before a test?Best solution by Yahoo! Answers
What are the best AV cables for an Xbox 360 to a HDTV?Best solution by amazon.com
What is the Best way to request for part time as a current full time employee?Best solution by everydaylife.globalpost.com

Just Added Q & A:

How many active mobile subscribers are there in China?Best solution by Quora
How to find the right vacation?Best solution by bookit.com
How To Make Your Own Primer?Best solution by thekrazycouponlady.com
How do you get the domain & range?Best solution by ChaCha
How do you open pop up blockers?Best solution by Yahoo! Answers

For every problem there is a solution! Proved by Solucija.

Got an issue and looking for advice?
Ask Solucija to search every corner of the Web for help.
Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.