Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

At work we have an ancient Ingress database that wont allow me to make links between tables using the SQL Query editor in Excel 2007.

My current solution is to generate the data in Crystal Reports, export it to excel and write a macro to then grab that data.

This works for my own purposes, but I am only contracted till June and would like to make these reports as automated as possible.

Is there a way to refresh the crystal report through an excel macro? Maybe through the likes of a batch file or shell script? Dont know much about either of those options but with only a minor java coding background am not even really sure what I should be looking to for the answer.

Thanks in advance!

share|improve this question
To resolve the issue, i created an odbc connection to the database and used the data sources tab in excel to directly import the data into excel – BiGXERO May 17 '12 at 23:53
if this worked for you, you should answer your own question and mark it as such. – datatoo May 24 '12 at 20:58
Will do. When i originally found the answer i did not have enough rep to answer my own question. Will provide a more detailed answer below – BiGXERO May 28 '12 at 3:27

You must log in to answer this question.

Browse other questions tagged .