SQL Server Performance

export data from Excel sheet to SQL Server table

Discussion in 'SQL Server DTS-Related Questions' started by tsvenumadhav, Dec 21, 2005.

  1. tsvenumadhav New Member

    hi

    i am new to sql server i have an excel file it contains data like

    stdid name age sex
    1111 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#


  2. Madhivanan Moderator

  3. FrankKalis Moderator

    Yes, please don't start multiple threads on the same question. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />

Share This Page