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 <[EMAIL PROTECTED]>
Homepage & PGP Key <http://www.pobox.com/~agreene/>
If it's too good to be true, it's probably Linux.
--
To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe"
as the Subject.
