Uploading values from excel to DB

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.

Howdy, Stranger!

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

Categories