Hi, --- On Mon, Dec 13, 2010 at 2:16 PM, Usha Murali <ushapram...@gmail.com> 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 your .xls. You can write a script with Perl (for example). To read .csv you can use Perl Text::CSV [1] and to write to database, use Perl DBI [2]. SK [1] Perl Text::CSV. http://search.cpan.org/~makamaka/Text-CSV-1.20/lib/Text/CSV.pm [2] Perl DBI. http://dbi.perl.org/ -- Shakthi Kannan http://www.shakthimaan.com _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
