Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Uploading values from excel to DB

sreemanthsreemanth Posts: 2Member
Dear Members here ,
I am newbie for this site, but hope to get some helping hand.I have an excel as shown below, i need to insert values from this sheet to Database

(excel sheet example)
Code Label
G1 Nokia
1 Nokia N series
2 Nokia C series
3 Nokia E series
G2
5 Sony Ericsson
G3 Samsung
6 Samsung Galaxy
7 Samsung Galaxy Tab
8 Samsung Windows
9 Samsung Base Model
G4
10 BLACKBERRY

But data in DB must me saved like this

Net code Label
G1 0 Nokia
G1 1 NokiaNseries
G1 2 NokiaEseries
G2 0
5 sony Erricson
G3 6 Samsung
G3 7 Samsung Galaxy Tab
G3 8 Samsung Windows
G4 0
10 BLACKBERRY
11 MOTOROLA

Code numbers should not be repeated other than 0 (zero or null. Help me with this ASSP

Sign In or Register to comment.