Text file data into table

• Mkumari

  Hall of Fame

  Points: 3498

  More actions

  June 3, 2002 at 1:22 pm

  #78816

  Hi

  I am having a task where in i need to insert the data in the text file into a column of the table.

  Here is the scenario, I have three folders with each having 1500 .Doc files with text data in them.What I want is the data from the .Doc file should go into the text column of the table programatically.

  Is there a way we can do this.

  Thanks in advance.

  Mkumari

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  June 3, 2002 at 4:00 pm

  #430251

  Lots of ways. You could loop through them using the file system object, open an ado connection, use a stream object to load them. You might also look at the Bii.exe that gets loaded with SQL under the sample code section.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter