Original source of data is MS Access with two fields:
ID (autonumber)
WordText (OLE Object, Object Type=MS Word)
I imported the Access database into a SQL Server database called, "MSWordTest." It imported like so:
ID (int 4)
WordText (image 16)
My code using Visual Interdev 6.0 (SP5):
------- Begin Code Sample --------------------------------
<!-- METADATA TYPE="typelib" FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->
<%@ Language=VBScript %>
<html>
<head>
<title>Test SQL Image datatype</title>
<meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
</head>
<body>
<%
Dim Conn, objRs
Dim SqlStr, strText
SqlStr ="SELECT * FROM Table1"
Set Conn = Server.CreateObject("ADODB.Connection"
set objRs=Server.CreateObject("ADODB.recordset"
Conn.ConnectionTimeout=60
Conn.Open "DSN=MSWordTestSQL"
objRs.Open SqlStr, Conn
Do Until objRs.EOF
response.contenttype = "application/vnd.ms-word"
Response.AddHeader "Content-Disposition", "filename=wordtest.doc"
strText = objRs.Fields("WordText"
.GetChunk(8000)
response.write "wordtext = "
response.write strText
response.write "<br><br>binary write = "
response.binarywrite objRs("WordText"
.GetChunk(8000)
objRs.MoveNext
Loop
objRs.Close
set objRs=Nothing
Conn.Close
Set Conn=Nothing
%>
</body>
</html>
------- End Code Sample -----------------------------------
The results:
wordtext = ?-
binary write = ì¥Á M ð ¿
bjbjâ=â= "
€W €W ÿÿ ÿÿ ÿÿ l ¨ ¨ ¨ ¨ ¨ ¨ ¨ Ü ö ö ö ö
...and so on!
I tried it without the contenttype & the .AddHeader & get similar results.
===========================================================
Maybe I'm taking a totally wrong approach to what I'm trying to accomplish. My user has some WordPerfect documents containing Job Description/Job Duty information. I want to create a database (first MS Access, then SQL Server in about 6 months) with this information. Some of the document lends itself nicely to database fields such as Job Title, Job Description, Job Classification, etc., but there are a couple parts of the document (job duties & qualifications) which are very textual and I need to maintain bolding, underlining, indentation, and carriage returns. I want a web front-end for the user to maintain this data. The data will also be displayed on the internet and will mimick their current WordPerfect document. I'm trying to keep conversion an easy task if possible, like doing a cut-and-paste operation into each data field I set up in the database. Is there a better approach to handling this task rather than the approach I'm trying here?
I appreciate your help!
