Hi,
I need to store word document data into database table .This is not one time process.I dont want to use SSIS.I need this to be done in code.
I have tried below code.It is working fine with .txt file,but not working well with .docx file.
It returns result like PK (garbage data).
DECLARE @LotsOfText VARCHAR(max)
SELECT @LotsOfText = BulkColumn
FROM OPENROWSET(BULK 'F:\pin\word\Tasks.docx',single_clob) AS x
select @LotsOfText
I have attached word file for which i am trying to load into table.
Thank you..