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.