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
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
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
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
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
> >
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
> 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:/
--- 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
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
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
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
11 matches
Mail list logo