how to extract word file and insert into sql database.

Question

how to extract word file and insert into sql database using asp.net C# ???

Manav Pandya · Answer

Hello You can follow given link : https://stackoverflow.com/questions/29892033/extract-word-document-data-and-insert-into-sql-database

Maen Badwan · Answer

Do you mean you have MS Word documents and you want extract text from them? Or do you mean you have images and you want to extract text from them and save MS Word document? In both cases, you can try using LEADTOOLS Document Viewer and conversion classes to do this. For example, you can use the DocumentPage.GetText() method to extract text from the document. The code will be something as follows: //You can use the following code to extract text from document and image files var options = new LoadDocumentOptions(); using (var document = DocumentFactory.LoadFromFile(Path.Combine(ImagesPath.Path, "Source.doc" ), options)) { var ocrEngine = OcrEngineManager.CreateEngine(OcrEngineType.Advantage, false ); var rasterCodecs = new RasterCodecs(); var documentWriter = new DocumentWriter(); ocrEngine.Startup(rasterCodecs, documentWriter, null , LEAD_VARS.OcrAdvantageRuntimeDir); document.Text.OcrEngine = ocrEngine; // get text var page = document.Pages[0]; var pageText = page.GetText(); if (pageText != null ) { pageText.BuildText(); var text = pageText.Text; Console.WriteLine(text); } else { Console.WriteLine( "Failed!" ); } You can find more details about the document features here: https://www.leadtools.com/help/leadtools/v19/dh/to/dox-topics-loadingusingleadtoolsdocumentslibrary.html https://www.leadtools.com/help/leadtools/v19/dh/to/dox-topics-parsingtextwiththedocumentslibrary.html