Getting web service data in a local table

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I am getting a dataset from a remote web method. I need to get the data in
the dataset into a local access table. Here is how far I have gone;

Dim ws As localhost.MyService
Dim ds As DataSet = ws.MyMethod
Dim da As OleDbDataAdapter

da.UpdateCommand.CommandText("SELECT srctble.* INTO [desttble]")
da.Update(ds)

What I can't figure out is a) what would be the name of the srctable if the
data is coming from a remote web method and b) what is the syntax of update
command if I want the data to go into a new table desttble in a local access
db.

Thanks

Regards
 
Hi John,

If you need to insert data, then use INSERT SQL statement, not SELECT INTO,
because you cannot specify DataTable as a source in your query
 
Back
Top