Hi there,

How do I write an HTML-File to the SQL-Server. (I want to place e-mail in a
Table)
I created a column HTMLbody with text as DataType.
I escaped ' and ".
And still, all the columns have a right INSERT, except for the HTMLbody.

thanks,


Michael

PS: I added a "test-string" that won't insert in the HTMLbodycolumn (even
not with string.replace(vbCrLf, Nothing) [vb.NET]. The insert works fine
with the other fields.

INSERT INTO tblEmailInbox (message, HTMLbody, sender, receiver) VALUES
('Hello,



This is just a test.

a.. [url]www.microsoft.com[/url]

For info: [email]michaelmerlot.com[/email]', '<!DOCTYPE HTML PUBLIC ""-//W3C//DTD HTML 4.0
Transitional//EN"">

<HTML><HEAD>

<META http-equiv=Content-Type content=""text/html; cht=iso-8859-1"">

<META content=""MSHTML 6.00.2800.1170"" name=GENERATOR></HEAD>

<BODY>

<DIV><FONT face=Tahoma size=2><SPAN

class=656053414-03072003>Hello,</SPAN></FONT></DIV>

<DIV><FONT face=Tahoma size=2><SPAN

class=656053414-03072003></SPAN></FONT>&nbsp;</DIV>

<DIV><FONT face=Tahoma size=2><SPAN

class=656053414-03072003></SPAN></FONT>&nbsp;</DIV>

<DIV><FONT face=Tahoma size=2><SPAN class=656053414-03072003>This is just a

test.</SPAN></FONT></DIV>

<UL>

<LI><FONT face=Tahoma size=2><SPAN class=656053414-03072003><A

href=""http://www.microsoft.com"">www.microsoft.com</A></SPAN></FONT></LI></
UL>

<DIV><FONT face=Tahoma size=2><SPAN

class=656053414-03072003></SPAN></FONT>&nbsp;</DIV>

<DIV><FONT face=Tahoma size=2><SPAN class=656053414-03072003>For info: <A

href=""mailto:michaelmerlot.com"">michaelmerlot. com</A></SPAN></FONT></DIV
></BODY></HTML>', 'MichaŽl Maes', 'MichaŽl Maes')