Re: [Ilugc] import xls data into mysql

2010-12-19 Thread manoj kumar
On Mon, Dec 13, 2010 at 2:16 PM, Usha Murali 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 ... > _ > > Try HeidiSQL[1] , a free front end for mysq

Re: [Ilugc] import xls data into mysql

2010-12-13 Thread Raja Subramanian
On Dec 13, 2010 2:17 PM, "Usha Murali" wrote: > Anyone done with importing xls data into mysql ; Ensure your data cells have correct formatting applied before you convert to csv using OpenOffice. Eg when I exported xls sheets to csv, phone numbers got messed up - lost leading zeroes, and lost t

Re: [Ilugc] import xls data into mysql

2010-12-13 Thread Kamalesh
On Mon, Dec 13, 2010 at 2:16 PM, Usha Murali wrote: > hi, > > 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 If you have open office, open the xls file using openoffice-calc and s

Re: [Ilugc] import xls data into mysql

2010-12-13 Thread Mohan L
On Mon, Dec 13, 2010 at 5:20 PM, Shrinivasan T 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. > > pyEx

Re: [Ilugc] import xls data into mysql

2010-12-13 Thread Asokan Pichai
xlrd is a good choice for python based reading of Excel sheets On 13 December 2010 17:19, Kenneth Gonsalves wrote: > On Mon, 2010-12-13 at 17:11 +0530, Raman.P wrote: > > > for xls to csv > > > conversion script ... > > > > you can try mysqlimport for loading data. First convert to csv using > >

Re: [Ilugc] import xls data into mysql

2010-12-13 Thread Kenneth Gonsalves
On Mon, 2010-12-13 at 17:11 +0530, Raman.P wrote: > > for xls to csv > > conversion script ... > > you can try mysqlimport for loading data. First convert to csv using > Openoffice. If too many files are to be converted try OO with headless > options or better using perl. or python ;-) -- rega

Re: [Ilugc] import xls data into mysql

2010-12-13 Thread Shrinivasan T
> 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 Explore these links. http:/

Re: [Ilugc] import xls data into mysql

2010-12-13 Thread Raman.P
--- On Mon, 13/12/10, Usha Murali 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 ... you can try mysqlimport for loading data. First convert to

Re: [Ilugc] import xls data into mysql

2010-12-13 Thread Shakthi Kannan
Hi, --- On Mon, Dec 13, 2010 at 2:16 PM, Usha Murali 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 ... \-- You haven't mentioned the data fields in yo

Re: [Ilugc] import xls data into mysql

2010-12-13 Thread Abishek Goda
Hi, > it would be helpfull even  if i could get the script for xls to csv > conversion script ... Open with any tool that can handle XL and do save-as-csv. I know MS Office does that. I am sure openoffice would. Abishek ___ ILUGC Mailing List: http://www

[Ilugc] import xls data into mysql

2010-12-13 Thread Usha Murali
hi, 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 ... ___ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc