-   Linux - Software (
-   -   mySQL and excel spreadsheet (

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.
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 06:43 PM.