On Mon, Dec 13, 2010 at 5:20 PM, Shrinivasan T <[email protected]>wrote:
> > Anyone done with importing xls data into mysql ; Could you kindly share > > the script > > (or) > > it would be helpfull even if i could get the script for xls to csv > > conversion script ... > > Hope pyExcelerator can help you. > > pyExcelerator : Python exportar MySQL to Excel > > This package appears to be no longer under maintenance.An alternative to most of the pyExcelerator functionality is offered by xlwt ( http://pypi.python.org/pypi/xlwt), which is a fork of pyExcelerator with immediate and continuing bug fixes and enhancements, and is supported on Python 2.3 to 2.6. I using MySQL : LOAD DATA LOCAL INFILE to load tab separated text file. Like this : LOAD DATA LOCAL INFILE Yourfilename.txt INTO TABLE Tablename FIELDS TERMINATED BY '\t'" LINES TERMINATED BY '\n' (filel1,filed2...); Thanks & Rg Mohan L _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
