How To Push Data From Excel To Sql Server?

I have written a simple ASP.NET MVC 2 application that stores data and can dynamically create excel files using Microsoft's openXML for excel files. What is the best way to push ch

Solution 1:

For anyone out there looking for a fix, I ended up using vba's InternetExplorer.Application object and interacting with an upload form on my site.

For more info on the upload form check out: http://haacked.com/archive/2010/07/16/uploading-files-with-aspnetmvc.aspx

For more info on VBA and the InternetExplorer.Application object check out: www.motobit.com/tips/detpg_uploadvbaie/

Solution 2:

You might take a look at Sql server integration services for bulk upload of data into sql server. The integration services once created can be run using a normal c# desktop program or using a windows service. But you might

• need to make sure this happens in the background and will have to be an asynchronous task.
• also need to make sure it is properly secured by not giving direct execute access to any other users

Solution 3:

I'm assuming that this is for a specific user. I've done something very similar to what you are describing before.

Tell the user to save the excel file in their DropBox and share the file with you. Have the server listen for changes to this file and run a server side routine to import the data.

Disclaimer: This is not a secure solution, but it's easy and will get the job done.