Excel through SOAP to a webserver

[Guest]

Hi

Is there a way to go from Excel through SOAP to a webserver? And further, is there a way to convert the returned xml into an ADODB recordset

Thanks.

 

[Tim Williams]

Yes and yes. I believe there's a MS SOAP SDK but you could perhaps
roll your own depending on the complexity of your app.

ADO recordset can be persisted to xml and then recreated from that
xml, but the format is specific to ADO and probably will not match the
server-generated xml (unless that is from an ADO recordset). You'd
have to load the xml into a document and iterate through it, filling
the recordset.

Tim.

Hi,

Is there a way to go from Excel through SOAP to a webserver? And

further, is there a way to convert the returned xml into an ADODB
recordset?

 

[onedaywhen]

Which version of Excel? e.g.

Microsoft Office 2003 Web Services Toolkit 2.01:
http://www.microsoft.com/downloads/...8A-E1CF-48A3-9B35-169D819ECF18&displaylang=en

Microsoft Office XP Web Services Toolkit 2.0
http://www.microsoft.com/downloads/...0f-002a-4f5b-af74-978f2cd6c798&displaylang=en