----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: kumarm Message 1 in Discussion 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 ----------------------------------------------------------- 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]