How to write text into word doc using SQL 2000 query analyzer
how to write text into word doc using sql 2000 query analyzer.
Thanks in advance.
Software/Hardware used:
Sql 2000
Software/Hardware used:
Sql 2000
ASKED:
November 19, 2010 7:02 AM
UPDATED:
November 19, 2010 2:28 PM
Answer Wiki:
I am using this procedure to create and append the doc file but no result get till now why ??anybody clear it ??
alter PROCEDURE sp_AppendToFile(@FileName varchar(255), @Text1 varchar(255))
AS
DECLARE @FS int,
@OLEResult int,
@FileID int
EXECUTE @OLEResult = sp_OACreate 'Scripting.FileSystemObject', @FS OUT
select @OLEResult
IF @OLEResult <> 0 PRINT 'Scripting.FileSystemObject'
--Open a file
execute @OLEResult = sp_OAMethod @FS, 'OpenTextFile', @FileID OUT, @FileName, 8, 1
select @OLEResult
IF @OLEResult <> 0 PRINT 'OpenTextFile'
--Write Text1
execute @OLEResult = sp_OAMethod @FileID, 'WriteLine', Null, @Text1
select @OLEResult
IF @OLEResult <> 0 PRINT 'WriteLine'
EXECUTE @OLEResult = sp_OADestroy @FileID
EXECUTE @OLEResult = sp_OADestroy @FS
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
