Hi, what parts are you comfortable with and what gives you trouble? Reading data from Excel, building the SQL statement, writing the SQL statement to a script, something else?
It is possible to treat Excel as a database with the JDBC ODBC Bridge but Sun says The JDBC-ODBC Bridge driver is recommended only for experimental use or when no other alternative is available. The POI library is another option to read Excel.
Do you have some "almost working" code?
A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
posted 11 years ago
No i am yet at design stage.
I am looking for the possible way in which one can do it. I heard abt jxl.* package and just want to choose the best option.