SQL Server Performance Forum – Threads Archive
export data from Excel sheet to SQL Server table
hi i am new to sql server i have an excel file it contains data like stdid name age sex1111 xxx 22 m
2222 yyy 10 f
3333 zzzz 44 m now i have a sql table like std_details stdid int
name varchar(50)
age int
sex varchar(1) now i want to export data from Excel sheet to SQL Server table from aspx page
please tell me the process..and give me some sample code in c#
Refer this
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=8440 Madhivanan Failing to plan is Planning to fail
you can use the DTS to do this. Option one,
put the excel sheet columns in the same order with same datatype and to import/export. Option two,
in the DTS only, select the source (excel sheet) and destination(SQL Table) and use query builder to select the table-columns, which is easier. -Johnson
]]>