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
 

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

Linking data in MS Word into Excel 5
OWC safe in ASP.NET? 9
ASP.NET and OWC Spreadsheet 7
OWC Spreadsheet and SpreadsheetML 2
How to get OWC PivotTable data into an Excel Application 1
Reading an Excel file using OWC 1
Reading Data from an Excel Sheet 1
OWC 11 Excel performance question 1

Top