Yili Li

Yili Li

  • NA
  • 9
  • 22.7k

Anyways to insert multiple rows into sqlserver?

Jun 3 2010 2:35 PM
I am dealing with some sort of daily data and I need to parsing those data out from txt files and save those into sqlserver database. What I did right now is just to read from those txts line by line and insert into tables. But the problem is, for each single day, it has more than 2 million rows which is really time consuming. 
I am just wondering, are there any ways I can make it more efficient? Any suggestion is welcome.

Thanks,


Answers (2)