Hi Nikhil
Is there any chance for you to provide the ODBC trace generated by ODBC DM /
MyODBC ?
Thanks in advance
Venu
> -----Original Message-----
> From: Nikhil Goyal [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 26, 2001 11:33 AM
> To: [EMAIL PROTECTED]
> Subject: Help with myODBC
>
>
> Hello people,
>
> I've a mysql database which is quite large and I needed to create a backup
> for it, which I can use offline in MS Access or such. I've tried using
> MyODBC, but one strange problem has come up. Certain fields (defined as
> TEXT) in my databast have multiple lines in them, separated by CRLF pairs.
> And when I inport using MyODBC, it only imports the first like of each
> field. Which means:
>
> If the initial database row was
>
> field1 field2
> x1 this is line1<CR><LF>this is line 2
> x2 something<CR><LF>more
>
> the import into access looks like this
> filed1 field2
> x1 this is line1
> x2 something
>
> does anybody have any suggestions on what I should do? Any help is
> appreciated
>
> Nikhil Goyal
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php