Inserting data from a .txt file to Database
ASP.NET
2
Posts
2
Posters
0
Views
1
Watching
-
Hi I want to know the code for reading a .txt file present in my system and then insert the text into the database. Eg:The text in .txt file is "FromDate|Todate|Reason for leave" Now i want this text to insert into databasetables with respect to thier fields Srinu
-
Hi I want to know the code for reading a .txt file present in my system and then insert the text into the database. Eg:The text in .txt file is "FromDate|Todate|Reason for leave" Now i want this text to insert into databasetables with respect to thier fields Srinu
you can insert data txt file into database through bulk Bulk insert tablename from 'c:\url.txt' with( FIELDTERMINATOR =',', ROWTERMINATOR = '\n' )