Database Update using Excel
Hi,
We have couple Excel files which are link each other for calculating values. Now we want to use Excel Service so that we can show the data to users based on their credentials. We know that Excel service won’t support external excel links.so we want to use following scenario, correct me if there is any better approach.
Because Excel service doesn’t support external excel links, we want to store all the information in the database. By using the Database Connection Library we can get information from the database and we can show to the user. Until this point it works for me.Now my question is
Can we use Excel as a front end and when user updates some values in the Excel, can we store those values back to database?
Note: macros won’t support by Excel service.
Guide me whether it is doable or not. If not this is my following alternative,
Alternative : need to develop some front end either using ASP.NET or Win App to update the database.
I will appreciate if guide me the better alternatives .
Thanks
Vijay
