in reply to From excel to mysql...

Hi Kiat, Can you provide above code for reference Thanks in Advance, Anusha

Replies are listed 'Best First'.
Re^2: From excel to mysql...
by Corion (Patriarch) on Jun 08, 2017 at 08:39 UTC

    Please read the thread. It provides much advice on how to write the code to import the data.

      What I want is to parse the excel file using ParseExcel and then have the perl script write the necessary sql statements into a outputfile for example insert statements.