Hello, I'm trying to insert data from a text file generated by our system into an SQL database. I have a button that will Delete info from the current database table so that whenever we get that .txt file it's replaced with that particular data. Basically I want to click that button> delete current data(accomplished)> Find .txt file from network share> read the .txt file data and store that data into Ms SQL Server Database table. This is an asp.net/c# application.
Is this done using the BULK INSERT code and if so how is it used? If there is another more intuitive way of doing so that would be greatly appreciated.
Let me know if some code is needed.