.txt file data into SQL Server 2008 database

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.

Thank you!
melfrancineBusiness Process Solutions ManagerAsked:
Who is Participating?
 
QPRCommented:
I would read the text file into a streamreader (system.io) and then insert this into your DB table.

List<string> txtValues = new List<string>();
string line;    
System.IO.StreamReader file = 
new System.IO.StreamReader("c:\\yourTXTfile.txt");
while((line = file.ReadLine()) != null)
{
   txtValues.Add(line);
}

Open in new window


Then for each line in your streamreader you could run an insert statement e.g.
"insert into theTable (column1) values ('" + varName + "')";
0
 
melfrancineBusiness Process Solutions ManagerAuthor Commented:
Thank you so much! This is the solution, I havent gotten the insert statements yet but I ran the trace and saw how it copied my data from the .txt file.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.