Hi,
Are you sure that .txt file is OK?

Regards,

Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
                                          [EMAIL PROTECTED]
----- Original Message -----
From: "Schroeder, Bradley (Contractor)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 7:06 PM
Subject: Problem importing data from Access


> When I import data from the text file I exported out of Access it works
> correctly except that MySql seems to append and/or prepend some sort of
> mystery character to the fields it imports.  So, I can get the data into
the
> database, but I can't get it out (since the SQL statement can't match the
> mystery character).  I'm using the graphical interface to import data
since
> it fails at the command line even though my version of MySql is a later
one
> than the required 3.22.15.  The GUI shows the mystery character as a bold
> pipe "|".  The command line seems to show a problem with the size of the
> field.  The select * from table statements look like this on the command
> line:
>
> +----------+
> |   Col 1  |
> +----------+
>   | data |
>      |ta    |
>    |dat|
> +----------+
>
> instead of this:
>
> +----------+
> |   Col 1  |
> +----------+
> |   data   |
> |   data   |
> |   data   |
> +----------+
>
> My guess is that there is a problem with the end of line character being
> exported to the text file from Access.  I chose "\n" as the end of line
> character to separate records, but maybe it is something else.
>
> Any ideas?
>
> Thanks,
>
> Brad
>
> ---------------------------------------------------------------------
> 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

Reply via email to