I have a project to which I need to upload files. I have to upload an excel file, select the file from the computer and pass it to a sql server database. I have tried with tools such as sql server data tools, but apparently it only allows me to upload a specific file.
If you say SQL Server Data Tools SSDT is a set of tools to work on database projects from Visual Studio for example. But it is for development, deploy. Not to work in applications.
If you want support in your ASP.NET web app for reading Excel spreadsheets then you should use the
componentsThat they are libraries that will help us to manipulate our office documents. For example, extract or edit the calculation sheets. For example to parse excel ...
And after you have the data parsed in an array or business object of your app, then it only remains to take them to DB through your data or services layer. But this is another issue. Here is the only thing I recommend if it is a large volume of data the best option is to Batch SQL
Links that can help you
I hope it can help or guide you