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
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
-
Try Mascon's Copy&Paste 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 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 aro