I like pipe delimited files, I just save it as tab-delimited files from
excel and run a little sed script to convert the tab's to pipe's.
Hope this helps.
Brian
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.
>
> 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.
>
>
------------------------------------------------------------------------
In the world of PC's. Ken Griffy Jr. is still the best thing in NW Wash.
Brian Schneider [EMAIL PROTECTED] www.liberty.ddns.org
________________________________________________________________________
--
To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe"
as the Subject.