November 14, 2001 5:31 PM
> To: Won Lee
> Cc: mysqlList
> Subject: Re: Text qualifiers
>
> Won Lee wrote:
>
> > I have an slew of Access DBs that I need to port some of the info into a
> > MySQL DB.
> > I guess my main problem is my I have no idea in what form
Look at MYSQL manual, sect. 6.4.9 LOAD DATA INFILE Syntax
That explains how to work around your problems.
-Original Message-
From: Won Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 14, 2001 3:30 PM
To: mysqlList
Subject: Text qualifiers
Hi everyone...
Long time listener
OTECTED]]
Sent: Wednesday, November 14, 2001 4:31 PM
To: '[EMAIL PROTECTED]'
Subject: Text qualifiers
>I tried to wrap the text in double quotes to tell it not to terminate the
line. However, my imports have still failed. This could be due to my lack of
experience or wrong syntax.
Won Lee wrote:
> I have an slew of Access DBs that I need to port some of the info into a
> MySQL DB.
> I guess my main problem is my I have no idea in what format to export my
> data from the Access DB.
> In general I export it as a tab delimited file with no text qualifiers.
>I tried to wrap the text in double quotes to tell it not to terminate the
line. However, my imports have still failed. This could be due to my lack of
experience or wrong syntax. But I did everything as told in the
documntations.
What parameters are you using for your import?
If you give us a
B.
In general I export it as a tab delimited file with no text qualifiers.
Unfortunately, much of the data has a carriage return as part of the data.
The carriage returns terminate the line and my import fails.
I tried to wrap the text in double quotes to tell it not to terminate the
line. However, my im
