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.

Reply via email to