try this:
1. export the data from ms access to a file on
the windows box.
2. fire up ftp from the command line and set it
to ascii mode.
3. ftp the file from the windows box to the
linux box.
if the eol is the problem, the ftp protocol will
insure that the eol is correctly translated when
moved to the new system.
> 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
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
---------------------------------------------------------------------
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
