unix shell script to load data into database

December 14, 2010 at 10:20:49
Specs: Windows XP
Here is the requirement:

I need to load an excel file into unix path. Excel sheet has 3 columns empno, empname, salary and it may contain many rows.
Now the data in the excel sheet has to be loaded into emp table with those respective columns. After successful insertion it should shoot a mail saying no.of rows inserted. In case of any errors, it should write a log entry,

Thank you


See More: unix shell script to load data into database

Report •

#1
December 15, 2010 at 20:44:14
Here is some information on doing it with perl:

http://www.ibm.com/developerworks/l...

If you use python, try this:

http://sourceforge.net/projects/pye...

Personally, I'd just create a CSV file and import it.


Report •
Related Solutions


Ask Question