(Answers that include advice to use xsd, please describe how to get the xsd from the wsdl!)
I've written up a webservices tier for my office's line of business application. However, unless I can figure out how to get the results into MS-Access or Excel without all the column names turning to strings, then my API is all dressed up with nowhere to go.
I was hoping the xml web services could act as a data source for ad hoc query purposes for users that can't access the database.
Having a WSDL file doesn't seem to do anything for MS-Office. I've attempted to extract an xsd manually from the WSDL and that doesn't seem to work (either it can't or it is an error prone process to extract an xsd)
Are there any third party tools or menu items in MS-Office I should try out?