Write to SQL from Microsoft word as source RRS feed

  • Question

  • I have a word file structured as below :

    Date : .........

    name : ........

    Type :..........

    Date : large text ........



    I want to insert the data into their respective fields in SQL Server database

    how this is done ?

    Monday, September 27, 2010 1:38 PM


  • Are you sure you have a Word document? Word document stored in a binary format and you do not see inside content in clear text. To parse it you need to use some sort of API, for example Office Tools for Visual Studio.
    Val Mazur (MVP) http://www.xporttools.net
    • Marked as answer by liurong luo Monday, October 4, 2010 3:32 AM
    Tuesday, September 28, 2010 11:00 AM