Uploading values from excel to DB - Programmers Heaven

Howdy, Stranger!

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

Categories

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.