Post reply

Insert word document in database

  • June 17, 2003 at 4:40 am

    #175959

    How do i insert a word document in sql server database, and then search for a word in that document

  • June 17, 2003 at 5:06 am

    #461683

    You could use BULK INSERT (That seems to be my solution for a lot of things) or BCP to insert it into a text field as plain text.

    Problem is it would retain the RTF formatting. Searching through it could be a normal like or you could try and extract keywords.

    Could also use English Query to search it although I don't know what the RTF is gonna do to it. I do not think it'll affect it as it's looking for words within the RTF.

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • June 17, 2003 at 1:48 pm

    #461816

    try using TextCopy cmd to load the document. You can schedule index\reindex on the text cols

  • June 17, 2003 at 1:56 pm

    #461817

    quote:

    and then search for a word in that document

    Use Full-Text search service.

Viewing 4 posts - 1 through 3 (of 3 total)

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