----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: ulab4 Message 2 in Discussion Hi, First import the excel data to gridview or dataset or some source where u can select columns in visual studiom 2005, and then u can easily insered the columns to different tables. To: [EMAIL PROTECTED] CC: [email protected]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] From: [EMAIL PROTECTED] Subject: Need help on Excel to Sql server more than one table Date: Mon, 16 Apr 2007 05:58:12 -0700 <META content="Microsoft SafeHTML" name=Generator> <STYLE> ExternalClass EC_ThmFgColumnHeader, .ExternalClass EC_A.FrameLink, ExternalClass EC_A.HeaderLink, .ExternalClass EC_A.FooterLink, ExternalClass EC_A.LgtCmd, .ExternalClass EC_A.MSNLink {color:#FFFFFF;} ExternalClass EC_ThmFgTitleLightBk {color:#FF6600;} ExternalClass EC_ThmFgSmallLight {color:#ff0000;} ExternalClass EC_ThmFgNavLink, .ExternalClass EC_A.NavLink, ExternalClass EC_A.ChildLink:hover {color:#666699;} ExternalClass EC_ThmFgInactiveText, .ExternalClass EC_A.SystemLink {color:#666666;} ExternalClass EC_ThmFgFrameTitle {color:#FFFFCC;} ExternalClass EC_ThmFgTitleDarkBk, .ExternalClass EC_A.NavLink:hover, ExternalClass EC_A.TitleLink {color:#CC6600;} ExternalClass EC_ThmFgMiscText, .ExternalClass EC_A.Cat, .ExternalClass EC_A.SubCat {color:#336699;} ExternalClass EC_ThmFgCommand, .ExternalClass EC_A.Command, ExternalClass EC_A.LargeCommand, .ExternalClass EC_A.MsgLink {color:#003366;} ExternalClass EC_ThmFgHeader {color:#333333;} ExternalClass EC_ThmFgStandard, .ExternalClass EC_A.SystemLink:hover, ExternalClass EC_A.SubLink, .ExternalClass EC_A.ChildLink, ExternalClass EC_A.StdLink, .ExternalClass EC_SELECT.Standard {color:#000000;} ExternalClass EC_ThmFgDivider {color:#CCCCCC;} ExternalClass EC_ThmBgStandard {background-color:#FFFFFF;} ExternalClass EC_ThmBgUnknown1 {background-color:#FF6600;} ExternalClass EC_ThmBgFraming {background-color:#666699;} ExternalClass EC_ThmBgUnknown2 {background-color:#666666;} ExternalClass EC_ThmBgHighlightDark {background-color:#FFFFCC;} ExternalClass EC_ThmBgHighlightLight, .ExternalClass #EC_idToolbar, ExternalClass #EC_tbContents {background-color:#FFFFE8;} ExternalClass EC_ThmBgTitleDarkBk {background-color:#F1F1F1;} ExternalClass EC_ThmBgAlternate {background-color:#ECF1F6;} ExternalClass EC_ThmBgUnknown3 {background-color:#CCCCFF;} ExternalClass EC_ThmBgDivider {background-color:#CCCCCC;} ExternalClass EC_ThmBgHeader {background-color:#9999CC;} ExternalClass EC_ThmBgLinks {background-color:#8696C9;} ExternalClass EC_ThmBgSharkBar {background-color:#8696C9;} ExternalClass EC_ThmBgGlobalNick {background-color:#9394A9;} ExternalClass EC_calfgndcolor {color:#E00505;} ExternalClass EC_calbgndcolor {color:#E00505;} </STYLE> New Message on BDOTNET Need help on Excel to Sql server more than one table Reply Reply to Sender Recommend Message 1 in Discussion From: kumarm Hi Everyone I want to import datas from excel sheet to sql server. But my requirement is: 1) I have to insert the datas into more than one table. 2) In my excel sheet if i am having 10 columns, first and third column will be inserted into one table and some other columns will be inserted into another table. 3) how to column mapping with excel to sqlserver. When i check the following url : http://www.sqlservercentral.com/columnists/vkumar/introductiontodtsinsqlserver2005.asp but i couldn't found the DTS (Data Transformation project) in sql server studio 2005 -> Business Intelligent Development Studio i am using sql server 2005 and visual studio 2005. Please help me to solve my problem. Any resource,url thanks in advance kumaran _________________________________________________________________ Free & easy posting . Yello Classifieds. http://www.yello.in/home.php?utm_source=hotmailtag&utm_medium=textlink&utm_content=in&utm_campaign=april View other groups in this category. To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from BDOTNET. Get the new Windows Live Messenger! Try it! ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
