I am very new to web services and I have to work on the following:
I am provided a web service url. When I run this url on a browser, I see a popup that asks about either opening or saving a Microsoft Excel file. When I select open or save option, it appropriately opens or saves the xls file on my hard drive. I want to consume this web service and import this xls file into a table in the SQL Server database. Can you please help me step by step i.e.
(1) How to consume the web service and receive the Excel file through my web service
(2) Import the data in the xls file using c#.NET into a table in the SQL Server database