Import data from excel and load into sql server

Question

Post reply

Import data from excel and load into sql server

vax09

Mr or Mrs. 500

Points: 591
More actions
August 7, 2012 at 1:31 pm

#149442

I need to import data from excel and excel has data like this for example
Column Name
Test01 test02 test03 test04 test05
Values
State2_J State4_A State2_H NUll NULL
State3_a State1_A State3_F NULL State4_P
In requirment all this data value become distinct column value like this
State2_A, State2_B,State2_J,State4_A
So i need to yes under appropriate column name and rest remain null for example
State2_A, State2_B,State2_J,State4_A
yes YES
Please Help me. any idea would be apericated.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Mordred SSCrazy Points: 2904 More actions · Answer 1

Are you using SSIS for your ETL purposes?

Regards:
Mordred
Keep on Coding in the Free World

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

Is

Test01 test02 test03 test04 test05

-----------------------------------------------------

State2_J State4_A State2_H NUll NULL

Do columns test04 and test05 contain

a. the charactes null, NULL

b. blank characters

c. EMPTY?

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

vax09 Mr or Mrs. 500 Points: 591 More actions · Answer 3

vax09

Mr or Mrs. 500

Points: 591

August 8, 2012 at 8:17 am

#1523135

Yes!!! I am using SSIS

vax09 Mr or Mrs. 500 Points: 591 More actions · Answer 4

I have many other column, in which i dont have any value that's why i specify null. As I mention earlier my data value are becoming column and we have to put "Yes" under apropriate column name.