How to load such a word format text data

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cuqsy0
    New Member
    • Apr 2012
    • 22

    How to load such a word format text data

    Hi SQL Gurus,

    I have a question on how to load text data in a MS word file. Here is the sample data:

    --------------------------------
    John is my friend. He is at 19.

    Smith asked me how old is John. I told him John is 19. Smith said John looks like 30.
    ---------------------------------

    So, I have two paragraghs, and each paragraphs have some sentences. Now I wish to load this data from a MS word file using SQL or T-SQL. The target table has only one column, "Paragrah". The first paragrah in that MS word file should be the first record, and the second paragraph should be the second record.

    Any sample SQL to do this?

    Thanks in advance.

    -CUQ
  • cuqsy0
    New Member
    • Apr 2012
    • 22

    #2
    p.s.

    I was trapped by this question because when I saved the MS WORD into plain .txt file, it sometimes breaks a paragraph into several lines, instead of a single line.

    Comment

    Working...