Jonathan,

If i want edit that what is the procedure.

What kind of network library enabled on your SQL server?.

Thanks,

Sreeni.

Try This .............

Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strWebFilePath & ";Extended Properties="""";Excel 8.0;HDR=Yes;"

Conn.Mode = adModeReadWrite

Conn.Open

Try this..

CREATE TABLE #file (line varchar(255) null)

INSERT #file EXEC master..xp_cmdshell 'Type D:\temp.html'

SELECT * FROM #file

DROP TABLE #file

Jonathan,

Thanks, it worked for me. But is it compatable for all versions?.