Re: Excel to Sql

2000-03-01 Thread Charles Galpin
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 shee

Re: Excel to Sql

2000-03-01 Thread Eric Cifreo
> 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

Re: Excel to Sql

2000-03-01 Thread Brian Schneider
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 s

Re: Excel to Sql

2000-03-01 Thread Anthony E. Greene
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

Re: Excel to Sql

2000-02-29 Thread Eric Cifreo
> 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: http://mysql.com/Man