Importing Excel Table into a MS SQL Table

I have software for STOCK and SALES that can give me an Excel price开发者_如何学Go list, I wanna write a small web app that will enable users to check prices, I don't have any access to that software's database, so I wanna import that Excel data (one worksheet, 5 columns, almost 10000 rows) into an MS SQL database table, keep in mind that the price list will change few time a month so I need to re-import that price list once its been updated.

Any suggestions? or maybe I should skip using an MS SQL database and directly use the Excel sheet? if so, then how?!

---

I'd go directly to SQL Server. Let it do the heavy lifting. If one of your users wants to export data to Excel, by all means provide such a feature. But multi-user changes to the data should be done in SQL Server via the web. Excel should be a local, read-only, personal copy to download and nothing else.

SQL Server can easily import an Excel spreadsheet or .csv file, especially if we're talking about a single table with five columns. I'd still have SQL Server do all the work on the web side.

---

If you save the Excel file as a CSV, it doesn't take much of a program to convert that into SQL statements.

---

You can use bulk upload to upload data from excel to sql server. Please look at the link below

http://www.gyansangrah.com/ArticleContent.aspx?ID=bulk_upload_in_asp_net

Please let me know in case of any issues.