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