Query

• Mvs2k11

  Ten Centuries

  Points: 1223

  More actions

  September 1, 2013 at 8:17 pm

  #282744

  I need a T sql query which should read and load text files data from the directory one file after another file and load the file data into a table.

  Thanks for your help in advance

• kapil_kk

  SSC-Insane

  Points: 21316

  More actions

  September 1, 2013 at 11:11 pm

  #1646658

  you can use BULK INSERT for loading data from a text file into SQL server table.....

  _______________________________________________________________
  To get quick answer follow this link:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/