Any way to Import/Link to TFS (Team Foundation Server)?

[kjv1611]

I'm looking for any way to link in a table query from TFS (Team Foundation Sever).

I'd ask this in forum1778, but there have only be 4 topics started at all, and the most recent was over a year ago.

Has anyone here attempted to pull that sort of data (application development planning) into an Access database before?

In a quick search online, I did not find anything about going from TFS to Access, but I did find several instances of the other way around.

Thanks for any help.





"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[kjv1611]

For anyone else who may need this, I ended up with 2 ways. One I found online (to get to Excel, not Access), and the other via a pure SQL method. The data is stored on a SQL Server, I just had no idea of its name. Also, on that server, thankfully, someone had cleaned up the data well enough with a view that we can query what data we need very easily.

The method for Excel I found is here;

http://msdn.microsoft.com/en-us/library/vstudio/dd286627(v=vs.110).aspx

It works out very nicely, though I think I'll use the SQL method since I can pull that straight into Access, which is where I was wanting to go with it - to query against a SharePoint List.



"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57