Reading data from MS Excel and uploading the data into DB in ASP.NET - using OWC

K

Kumar

Hi
we have a requirement where we need to read from the spreadsheet,
selected by the user at the client side and upload it into the DB. Any
code snippets on this would be helpful

Thanks
Kumar
 
A

Alvin Bruney [MVP]

i suspect your enduser is using desktop excel, you will probably need to use
excel interop to accomplish this. I think there are a few snippets on msdn.
I'm sorry i do not have any links to these.

If you want to use owc, then the process is easier but you have licensing
issues to contend with so choose carefully.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
 
Top