BULK INSERT in MS SQL SERVER

In IT environment, it is always a necessary to import data from data files into database.And recently, I have to deal with import a huge load of data (around 200 MB for 1 CSV input file) from CSV files into MS SQL SERVER. So what I had done to achieve this is by using BULK INSERT.Firstly, prepare a CSV data file with the following content and save as test.csv.July,Singapore,25James,Australia,50May,China,29And then run scripts as following to load all the data from the CSV file into database.--Temp table to store the dataCREATE...

Kill Excel.exe Process in C# .NET

I am trying to get my C# .NET codes to generate reports into excel files. In the Export function, it creates the excel object, adds in the data and then saves the file.All of this works fine. But for some reason, the excel.exe process is still running when I check from task manager.I had tried to quit the excel application. I had tried to use InteropServices.Marshal.ReleaseComObject to get rid of them in .NET. But unfortunately, the excel.exe is still sitting in memory.Finally, I found a way to kill the process in C# .NET. Take...