Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Import excel data in sqlserver 2000 without using DTS

Import excel data in sqlserver 2000 without using DTS

Scheduled Pinned Locked Moved ASP.NET
csharpasp-nethelp
6 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • F Offline
    F Offline
    farogh haider
    wrote on last edited by
    #1

    Hi, I want to import excel data in sqlserver 2000 using asp.net 2.0 Please help me asap. thanks

    Farogh Haider Web developer

    S F 2 Replies Last reply
    0
    • F farogh haider

      Hi, I want to import excel data in sqlserver 2000 using asp.net 2.0 Please help me asap. thanks

      Farogh Haider Web developer

      S Offline
      S Offline
      sashidhar
      wrote on last edited by
      #2

      R u looking For this..! Import Data from Excel to SQL Server[^]

      LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.

      F 1 Reply Last reply
      0
      • F farogh haider

        Hi, I want to import excel data in sqlserver 2000 using asp.net 2.0 Please help me asap. thanks

        Farogh Haider Web developer

        F Offline
        F Offline
        FEMDEV
        wrote on last edited by
        #3

        If it's just a table that you need to get in excel, go for a excel macro. not more then 5 lines of code.

        S 1 Reply Last reply
        0
        • F FEMDEV

          If it's just a table that you need to get in excel, go for a excel macro. not more then 5 lines of code.

          S Offline
          S Offline
          sashidhar
          wrote on last edited by
          #4

          He is asking using asp.net not vb macros brother..!

          LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.

          1 Reply Last reply
          0
          • S sashidhar

            R u looking For this..! Import Data from Excel to SQL Server[^]

            LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.

            F Offline
            F Offline
            farogh haider
            wrote on last edited by
            #5

            Thanks alot, It's working fine. can we use bulk insert.

            Farogh Haider Web developer

            S 1 Reply Last reply
            0
            • F farogh haider

              Thanks alot, It's working fine. can we use bulk insert.

              Farogh Haider Web developer

              S Offline
              S Offline
              sashidhar
              wrote on last edited by
              #6

              Dont Forget to mark it answer if it helps..!

              LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.

              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups