Post reply

Text file data into table

  • 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

  • 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
    Connect with me on LinkedIn

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply