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, fi
LOAD DATA LOCAL INFILE 'C:/Documents and Settings/won/My
Documents/summary.txt' INTO TABLE spacedx.summary FIELDS TERMINATED BY '\t'
OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
(groupID,structural,mechanical,electrical,safety,vertical,misc)\
I'll save the trouble of cutting and pasting th
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.
> Unfortunately, mu
