This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
You may do the following,
1. Split the line based on comma
2. Remove the surrounding single quotes
3. Take the necessary (red coloured text) data
4. Construct a INSERT statement, use JDBC and do the needful
Not many get the right opportunity !
Joined: Jul 15, 2011
But that is my query
"How to select that particular(red text)" ony?
Can you please write code for that?It's very urgent
If you check out our AccessingFileFormats FAQ, section "Excel", you will find several CSV libraries. You can use one of these to assist you in steps 1-3 in Madhan's procedure. A single PreparedStatement will help you with step 4.