Consuming Web Services - Going From A Manual Method To An Automatic One Using Third Party Provided WSDL

We have a small VB.net application that basically pulls information from our dBase and then exports this information to an .xls file. From this .xls file, in house agents then manually update a third party listing service (which maintains our current inventory) with the information contained within. The information is very basic, consisting of, for ease of discussion, a 'Part Number', a 'Description' and a 'Quantity On Hand.'

Normally we update this information once a week, but, a newly revised contract with this listing service now requires a daily update to maintain our 'platinum' vendor status.The problem is that it can take quite some time to manually update this information. an automated process is in dire need. And I have finished most of the ground-work and coding - up to a point. Hence the question, and hence where I get stuck.The listing service has provided us with the following WSDL's: One for Increasing our Inventory, one for Decreasing our inventory, one for Adding inventory and one for Removing Inventory.

Up to this point, I have re-programmed a Stored Procedure that was generating the exported information. this SP now does some internal math to figure out if a transaction result occurring on 'yesterday' was an 'Increase', a 'Decrease', an 'Add' or a 'Remove.' These results are then added to a result table under a newly created column named 'SERVICE.' This new information is then pulled from the dBase with vb.net and imported into a Data Table for analysis.

With this Data Table, I can now loop through each row, looking in the column 'SERVICE' and depending on the information contained in that cell, call the appropriate web service.

[Code]...

I realize that this has become quite long winded, mostly because on any given day I have 25 FF tabs open and none of them agreeing with each other. To add another wrinkle; the WSDL's in question use a lot of complex types within complex types with, you guessed it, other complex types entwined.