Updatable excel sheet on Web pages

[Devanand]

Hi!
I need to display an excel sheet kind of controls for my
HR department to Upload the data from my asp page. The
typical process is, they will enter all the key
information on the web page preferably in an excel sheet
embedded.
Once they click submit, the excel sheet should update the
database.

I hope Office Web Component can help me.
Can any one pls help me out, how to do that in ASP with
OWC components.
Or is there any other way, where we can show them a grid
like controls for bulk inserts to Database?

Thanks and regards
Devanand

 

[Alvin Bruney]

OWC is an excellent choice for this. Basically you will embed an excel
spreadsheet into your webpage. Next you need to write code to loop thru the
rows on the excel spreadsheet and build your queries from that. Then use
your queries to insert into the database.

You will need to obtain and install the OWC components from the microsoft
office website. Pay special attention to licencing issues.

 

[Devanand]

Hi!
You are right.
Is there any samples available as how to embed and access
row data from spreadsheet?

Thanks
Devanand

 

[Alvin Bruney]

It so happens that there is:
watch for line wrap

OWC
http://www.microsoft.com/downloads/...59-0A86-4FB2-A7EE-5F3A499515DD&displaylang=EN

Tutorials
http://www.microsoft.com/downloads/...77-2100-4586-A13C-50E56F101720&displaylang=en

 

[Devanand]

hi!
Thanks and I will try and workout

-----Original Message-----
It so happens that there is:
watch for line wrap

OWC
http://www.microsoft.com/downloads/details.aspx? FamilyID=982B0359-0A86-4FB2-A7EE-
5F3A499515DD&displaylang=EN
FamilyId=BEB5D477-2100-4586-A13C-
50E56F101720&displaylang=en




.