LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   mySQL and excel spreadsheet (http://www.linuxquestions.org/questions/linux-software-2/mysql-and-excel-spreadsheet-64554/)

zuessh 06-09-2003 12:29 PM

mySQL and excel spreadsheet
 
I am attempting to put data from an excel spreadsheet into a mysql database. From what I have found searching, there is a LOAD function in mysql, and there is also software you can buy to do this. What is the best way to do this? Thanks.

j-ray 06-12-2003 07:26 AM

if u just want to insert the data of the excel file into the db u best use a perl script. there's a module available for transforming excel data to xml.
http://search.cpan.org
-->XML::Excel
then u can insert the data in a mysql table. the data type for this sort of data would be text or some sort of blob depending on it's size.
are u familiar with perl and sql?
cheers, jens


All times are GMT -5. The time now is 01:20 PM.