current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I want to create a ASP.NET application which will fetch and store data from excel. For eg. currently i have automated excel reports using VBA and Macros, and user have to oem all the excels to get the data/charts/tables. All i want to let them open an asp.net application and from there only they can fetch reports, edit the reports and save the data and my excel will be used as DB. Please suggest is it's possible and if possible.

share|improve this question
1  
web is multi user environment, and excel is not well suited for concurrent access, so I would avoid this solution. –  Giedrius Jun 12 '13 at 7:26
    
@Giedrius I understand your concern, but still was thinking to avoid my users multiple excels and let them do all at a place in case possible –  Mukesh Jun 12 '13 at 7:31

1 Answer 1

up vote 0 down vote

As far as extracting the excel spreadsheet data you can take a look at this post to see a couple alternatives.

As far as getting around the concurrent access issue, you can store the excel information in some form of multi-user concurrent persistant storage - could be on disk or in-memory store (sql server, couchbase, memcache, etc...) and then access information from that store on user request.

share|improve this answer
    
i think you are missing a link under the this post :P –  vba4all Jun 12 '13 at 9:50
    
whoops! will fix, thx :) –  bbqchickenrobot Jun 12 '13 at 17:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.