Hi All, I have a few questions. I have a database and I have queries I run weekly on this database. I want to be able to link these queries to excel and refresh say once a week and be able to plot grahs with the values returned from the queries.How do I go about this.
I want to be able to populate an excel spreadsheet without opening the database, then use these results to plot graphs. I want to have say an application with a refresh button that once I click on this refresh button, my queries are run, my excel spreadsheet is populated and then a graph is ploted. Can any one help me with this. Thanks