Prev: How to use CDO to send mail with attachment
Next: Table Spool/Lazy Spool is a symptom of what?
From: BootieDay on 15 Feb 2005 10:29
I imported MySQL tables into an Access MDB and confirmed that the Access
table preserved the embedded new line (0x0A) characters within a memo field.
I then used an Access append query to insert data into a linked MS-SQL 2000
table consisting of an NTEXT field. The embedded newline characters were
dropped. What do I need to do to preserve this (and other) embedded "special
characters" for formatting? thx
From: Louis Davidson on 15 Feb 2005 13:31
It shouldn't be dropped. Could do the append query with profiler on and see
what the query being sent is? This will let us point a finger at the right
tool.

--
----------------------------------------------------------------------------
Louis Davidson - drsql(a)hotmail.com
SQL Server MVP

Compass Technology Management - www.compass.net
Pro SQL Server 2000 Database Design -
http://www.apress.com/book/bookDisplay.html?bID=266
Blog - http://spaces.msn.com/members/drsql/
Note: Please reply to the newsgroups only unless you are interested in
consulting services. All other replies may be ignored :)
"BootieDay" <BootieDay(a)discussions.microsoft.com> wrote in message
news:6A46CA21-E8EC-4107-9946-37A8370422A5(a)microsoft.com...
>I imported MySQL tables into an Access MDB and confirmed that the Access
> table preserved the embedded new line (0x0A) characters within a memo
> field.
> I then used an Access append query to insert data into a linked MS-SQL
> 2000
> table consisting of an NTEXT field. The embedded newline characters were
> dropped. What do I need to do to preserve this (and other) embedded
> "special
> characters" for formatting? thx


 | 
Pages: 1
Prev: How to use CDO to send mail with attachment
Next: Table Spool/Lazy Spool is a symptom of what?