Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 EXCEL TO SQL SERVER

Author  Topic 

anil_p
Starting Member

3 Posts

Posted - 2012-10-29 : 10:09:06
HI,

HELLO I TRY TO LOAD THE DATA FROM EXCEL TO SQL SERVER DB,
IN MY EXCEL SHEET I GOT 40 COLUMNS I WANT LOAD THE DATA INTO SQLDB (DON'T USE DATACONVARTION TRANSFORMATION) USING SSIS

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-10-29 : 10:14:49
use a data flow task with excel source and OLEDB destination for this

Didnt understand the deal with data conversion. why you dont want to use it? or is it an assignment question?

And please refrain from using caps while posting!
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2012-11-02 : 05:15:43
Have you tried this?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -