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.
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?
|All times are GMT -5. The time now is 01:43 PM.|