SQLTeam.com | Weblogs | Forums

Data from bought in software to excel


#1

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


#2

for real time data, you might want to consider putting the query in Excel, then users can update the results in real time