Re: Excel to Sql

["Anthony E. Greene" <agreene pobox com>]

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.

Tony
-- 
 Anthony E. Greene <agreene pobox com>
 Homepage & PGP Key <http://www.pobox.com/~agreene/>
 If it's too good to be true, it's probably Linux.