We have a bought in project accounting software, the reports are not good or dynamic, what I am hoping to achieve is linking an SQL query to Excel, to get real-time data, would you recommend this as the best way to carry this out? Basically an example of the data I want is project name, then list of resource with cost under a specific date or date range for each project. Is there a better way to connect to get this into excel. The data is in various different tables under one database.
Thanks
for real time data, you might want to consider putting the query in Excel, then users can update the results in real time