Upload-Excel-file-into-Ms-sql-database-on-Web This is a code that shows how to upload an Ms Excel file into a MS Sql database stored on a web server, i used EPPLUS.

Excel spreadsheets are fantastic bits of kit, but databases are not. Rather than making the full jump to replacing Excel with a database system, there is a halfway house you can consider.

You can create a release to package software, along with release notes and links to binary files, for other people to use. Learn more about releases in our docs ...

Warnings When you import a spreadsheet into an OpenOffice.org database, you lose any text styling, number formatting, macro scripts or charts that you previously used to enhance the data.

Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.