Import excel data into SQL server -- ASP.net, C#, DTS -- how??

Discussion in 'ASP .Net' started by Rathtap, Jun 30, 2003.

  1. Rathtap

    Rathtap Guest

    I want to set up the import of data from an excel file into SQL Server
    from my ASP.net (C#) application. The user will select the file that
    needs importing.
    I want to use DTS to do this. I was thinking of calling the DTS and
    passing it the name of the file to import.
    Is this the best way to do it? Any code available anywhere?
    Rathtap, Jun 30, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Sreedhar Vankayala
    Replies:
    2
    Views:
    13,551
    Sreedhar Vankayala
    Feb 25, 2004
  2. Jake
    Replies:
    1
    Views:
    685
    Ian Oldbury
    Apr 7, 2004
  3. jonefer

    How can I call a DTS (SQL Server 2000) from VISUAL BASIC.NET

    jonefer, Feb 15, 2007, in forum: ASP .Net Building Controls
    Replies:
    0
    Views:
    124
    jonefer
    Feb 15, 2007
  4. peteyjr

    import into excel file from SQL-Server

    peteyjr, Feb 11, 2004, in forum: ASP .Net Web Services
    Replies:
    0
    Views:
    137
    peteyjr
    Feb 11, 2004
  5. Ken Fine
    Replies:
    1
    Views:
    186
    Bob Barrows
    Nov 26, 2003
Loading...

Share This Page