Upload Excel data to web service

H

Hiran de Silva

Hi,

I usually setup users to upload data from Excel to SQL2005 via ADO
with VBA - going row by row firing off an INSERT on each row. Ok.

I am now looking at changing this to uploading to a web service (then
to SQL2005), that I will create with .NET.

My general question is, can the whole block of data be uploaded 'in
bulk' rather than row by row? I'm thinking, can the block of data be
an object that can be passed to the web service 'elegantly'?

Can someone point me to the steps please? A tutorial? Or main topics I
should read about?

Thanks!
 

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

Similar Threads

React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Excel VBA as a web service 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Efficient Excel to Access uploads 1
Creating a Chart on form from selected data in query. 0
Upload Excel data to Access error 1
Fetching data from WCF/Web service? 0

Top