I dont understand this argument against csv. Commas in CSV values are
legal, and quote marks are escaped as necessary (or it's not valid CSV).
charles
> On Wed, 1 Mar 2000, Anthony E. Greene wrote:
>
> > Eric Cifreo wrote:
> > >
> > > > Is there a way to import a table from an excel spread sheet to a MySql
> > > table??
> > > >
> > > > Kirk
> > > >
> > >
> > > In Excel, select export to csv (comma separated value) file. Transport this
> > > to your Linux machine, and take care of any Dos2Unix problems (like ^Ms,
> > > etc.). Then go read this link:
> >
> > If MySQL can import tab-delimited files, then that's generally a better
> > choice, especially if any of the columns contain text that may include a
> > comma (deliberately or otherwise). Someone could accidently type a comma
> > instead of a period in an abbreviation or something. Such an unintentional
> > comma could corrupt your import.
> >
> > In most data entry applications, a tab moves to another field or does
> > nothing. So it is unlikely that a tab will make it into a database
> > accidently. This makes tabs very good delimiters when importing/exporting
> > data. In PostgreSQL, tab is the default delimiter.
--
To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe"
as the Subject.
