in reply to Re: Re: From excel to mysql...
in thread From excel to mysql...
Actually impossible from the point of view of an import utility:
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES [STARTING BY ''] [TERMINATED BY '\n'] ] [IGNORE number LINES] [(col_name,...)]
Embedded newlines make it hard to define what represents a 'row'. Fortunately AFAIK you can't insert newlines into an Excel cell string as it triggers moving you to a new cell.
cheers
tachyon
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: Re: Re: From excel to mysql...
by jmcnamara (Monsignor) on Apr 13, 2004 at 19:39 UTC | |
|
Re: Re: Re: Re: From excel to mysql...
by diotalevi (Canon) on Apr 13, 2004 at 16:49 UTC |