Change DOCX to DOC in SQL

  • I have documents that were originally saved as Word 2000 documents with a doc extension. Because of a db corruption I had to import these documents back in and now they have a Word 2007 extension of docx. I need to change these extensions. Are there querys that can help me with this. I can't just arbitrarily change the extensions because in the db they are still docx.

    All help is appreciated.

  • If you're saying you have a load of DOCX documents in BLOBs then I would advise you to export them, use a batch converter, and import them back in.

    Trying to do that conversion in-place would be a world of pain.

    Atlantis Interactive - SQL Server Tools
    My blog[/url]
    Why I wrote a sql query analyzer clone

  • I'm with Matt on this one, SQL is not the place to do this.. Convert them back and re-import them..

    CEWII

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

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