Professional Web Applications Themes

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

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?...

  1. #1

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

    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 Guest

  2. #2

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

    you have to read excel file and then write to database

    Read Excel File :

    http://csharp.net-informations.com/excel/csharp-read-excel.htm

    Write to Database :

    http://csharp.net-informations.com/excel/csharp-excel-oledb-insert.htm

    this will help you

    Dell.
    dellmerca is offline Junior Member
    Join Date
    Feb 2012
    Posts
    2

  3. #3

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

    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.
    kolleen.koby is offline Banned
    Join Date
    Mar 2012
    Location
    NY
    Posts
    10

Similar Threads

  1. Import Excel Data into Property List
    By ctp webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 7
    Last Post: October 1st, 02:00 PM
  2. Move data from Excel to SQL Server via ASP
    By midwesthills in forum ASP Database
    Replies: 6
    Last Post: August 3rd, 08:18 PM
  3. Problems with Excel Data-Import
    By gregg_sales@adobeforums.com in forum Adobe Indesign Windows
    Replies: 6
    Last Post: April 20th, 08:31 PM
  4. import into excel file from SQL-Server
    By peteyjr in forum ASP.NET Web Services
    Replies: 0
    Last Post: February 11th, 03:29 PM
  5. Need to import data to excel
    By sudha in forum ASP.NET General
    Replies: 0
    Last Post: June 26th, 09:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139