Click here to Skip to main content
15,068,678 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
i want the code to import excel data from excel file to sql server 2005 table
using DTS package in c#
Posted

1 solution

Use SQL Server management studio for 2008 or latest versions, it provides Wizard like Imports, which you can usually make changes to column you want to load, data types, change SQL statements also,

Works for most scenario, you have option to generate script also which later you can modify
   
Comments
Dipesh202 25-Jun-12 3:08am
   
but i require code to implement it in c#
so that i can import excel file to db

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900