Table mapping error

J

John

Hi

I am trying to store data returned form a web service into a local access
table. The problem is that I am getting an "Update unable to find
TableMapping['Table'] or DataTable 'Table'" error on the line indicated
below. What is the problem and how can I fix it?

Thanks

Regards

Dim ws As New localhost.StaffDiary
Dim ds = ws.GetStaffDiary
Dim da As OleDbDataAdapter = New OleDbDataAdapter("select * from [Local
table]", conn)
Dim cb As OleDbCommandBuilder = New OleDbCommandBuilder(da)

da.InsertCommand = cb.GetInsertCommand()
da.Update(ds) '<=== This lines comes up with the error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,995
Messages
2,570,236
Members
46,822
Latest member
israfaceZa

Latest Threads

Top