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!

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.