I need to retrieve data from a web service. The only way I've found of getting at the service (and its data) is via a .NET add-in for Access. Within the add-in, I've followed the instructions from http://msdn.microsoft.com/en-us/library/aa902693.aspx to tie the add-in to a form in my Access database to do a prototype. Now I'm to the point where I want to push the data retrieved into the database.
Within the add-in there are 2 main subs, one to connect to the service and another to iterate through the records to get all the data.
My problem is I'm lost. If I could do the connection & iteration from VBA I'd know how to get the data into the database but I'm getting lost trying to figure out how to get the data in.
Is there something equivalent to Currentdb() in dao/ado/? I can use in .NET? The database is already open since the VB was launched from a command button in an Access form. Pull the data to a hidden list box on the Access form then push it in from there? I'm using Dev Studio 2008 with Access 2007 if that matters.
Any suggestions/comments would be appreciated.
-Lution
Within the add-in there are 2 main subs, one to connect to the service and another to iterate through the records to get all the data.
My problem is I'm lost. If I could do the connection & iteration from VBA I'd know how to get the data into the database but I'm getting lost trying to figure out how to get the data in.
Is there something equivalent to Currentdb() in dao/ado/? I can use in .NET? The database is already open since the VB was launched from a command button in an Access form. Pull the data to a hidden list box on the Access form then push it in from there? I'm using Dev Studio 2008 with Access 2007 if that matters.
Any suggestions/comments would be appreciated.
-Lution