Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: importing word document into sqlserver

    chapter1
    Delegates officially are to nominate Cheney as the GOP's vice presidential candidate before he addresses the group Wednesday night.
    chapter2
    "I think that the vice president's speech tonight is going to be about big issues, the big issues of this campaign -- the war on global terror, the president's education policy, the fact that the economy is turning up again," she told CNN's "American Morning."
    chapter3
    She said she had known her husband since he was 14 and planned to share anecdotes that many people have not heard before in her introduction.
    Chapter4
    Maverick Democratic Sen. Zell Miller of Georgia is scheduled to deliver Wednesday's keynote address -- a role he also played at the 1992 Democratic National Convention, which nominated President Clinton.
    Chapter5
    In the earlier speech, Miller, then governor of Georgia, said that "for 12 dark years, the Republicans have dealt in cynicism and skepticism. They have mastered the art of division and diversion, and they have robbed us of our hope."

    I wanted to import the above word doc into my sql server DB.
    I have two columns in the table
    1.Chaptereid
    2.chapter_notes
    chater1,chater2,chapte2,chapter3,chapter4 and chapter5 should go into chaptered column and the text followed by the chapter id should be imported into chapter_notes column.

    So how can I import this document.

    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Well....

    I would say that if you want to work with "Data", you'll need to save the document as pure text or at least as an rtf..

    To store a word doc, you'd need to store it in a text or image column....

    So assuming you save it to text, I'd start by loadinging in to a table with 2 columns.

    One that is an identity column and one thats varchar

    However, there is no gaurentee that the rows will "load" themselves in the correct order.

    But lets say they do, you could probably find the "row numbers" that make up the segements you are looking for....

    Just don't trust it to be 100% all the time.

    To 100% your document or text file would need to be tagged with their relative positions.

    Also, you might want to look into your content....damn left wing drivel...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Well....

    I would say that if you want to work with "Data", you'll need to save the document as pure text or at least as an rtf..

    To store a word doc, you'd need to store it in a text or image column....

    So assuming you save it to text, I'd start by loadinging in to a table with 2 columns.

    One that is an identity column and one thats varchar

    However, there is no gaurentee that the rows will "load" themselves in the correct order.

    But lets say they do, you could probably find the "row numbers" that make up the segements you are looking for....

    Just don't trust it to be 100% all the time.

    To 100% your document or text file would need to be tagged with their relative positions.

    Also, you might want to look into your content....damn left wing drivel...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •