Re: Excel-MySQL

2001-02-15 Thread Joe Ferrara
I am not a Perl Guru. How would I set up this environment? Or is there another way to go from excel to MySQL? -- Joseph Ferrara Member of the Engineering Staff LOCKHEED MARTIN Naval Electronics Surveillance Systems

Re: Excel-MySQL

2001-02-15 Thread Peter Skipworth
Save to a CSV (comma-delimited file) from Excel, and take a look at the "load data infile..." command within the mysql documentation. regards, P On Thu, 15 Feb 2001, Joe Ferrara wrote: I am not a Perl Guru. How would I set up this environment? Or is there another way to go from excel

Excel-MySQL

2001-01-31 Thread Ashley M. Kirchner
Not sure if this was ever asked, but I'm fighting a dilemma over here and the answer to this greatly affects what I'll end up doing: I know I can PULL FROM an MySQL database (sitting on a Limix box) INTO MS Excel. And that works great. However, I'm looking for a way to go the other way

RE: Excel-MySQL

2001-01-31 Thread Jacques Venter
Try Mascon's CopyPaste or Import Export: http://www.scibit.com/Mascon -Original Message- From: Ashley M. Kirchner [mailto:[EMAIL PROTECTED]] Sent: 31 January 2001 20:19 To: MySQL Mailing List Subject: Excel-MySQL Not sure if this was ever asked, but I'm fighting