You may also want to check CPAN for Spreadsheet::ParseExcel. I haven't dug
into it too deep yet, but it looks like it can parse native .xsl data.
Brian
-----Original Message-----
From: Ken Menzel [mailto:kenm@stripped]
Sent: Monday, February 19, 2001 11:08 AM
To: Joe Ferrara; mysql@stripped
Subject: Re: MySQL-Excel data correlation
> We have a ton of data in MS Excel that I need to put into a Solaris
> based MySQL dB. The data needs input such that it correlates across
> several different tables (i.e. I can't just do table dumps). What
is
> the most efficient way to do this?
>
> Thanks,
>
> Valerie
Hi Valerie, My opinion would be to export the data as a .csv (comma
separated values) then write a perl script on the Solaris box to
import the data into the tables you have setup.
Ken
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thread65773@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-brian.kaney=listorama.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
