D
Dave
I am a long-time VBA/Access developer but a newcomer to web services.
I have data in an Access table that I need to write to a SQL Server
table via web services. The web services developers have provided me 3
functions to do this - Initialize, which retrieves an instance ID,
Import, which is called for each row of data to be transferred, and
Finalize, which runs after all records have been transferred.
The developers are not VB guys and have not able to tell me how to
invoke these functions in my code, and my examination of the functions
leaves me clueless as to how to use them - obviously they wrap my data
in xml tags and send it to SQL Server, but I have no idea how to pass
the data to them.
I find reams of info online about creating web services, etc., but
have found nothing to help me use a service that already exists.
Any suggestions would be appreciated.
Thanks
Dave
I have data in an Access table that I need to write to a SQL Server
table via web services. The web services developers have provided me 3
functions to do this - Initialize, which retrieves an instance ID,
Import, which is called for each row of data to be transferred, and
Finalize, which runs after all records have been transferred.
The developers are not VB guys and have not able to tell me how to
invoke these functions in my code, and my examination of the functions
leaves me clueless as to how to use them - obviously they wrap my data
in xml tags and send it to SQL Server, but I have no idea how to pass
the data to them.
I find reams of info online about creating web services, etc., but
have found nothing to help me use a service that already exists.
Any suggestions would be appreciated.
Thanks
Dave