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. Database & SysAdmin
  3. Database
  4. BULK INSERT using oracle ODBC driver

BULK INSERT using oracle ODBC driver

Scheduled Pinned Locked Moved Database
oraclequestion
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.
  • H Offline
    H Offline
    hatemtaleb
    wrote on last edited by
    #1

    hello all, is it possible to load data from csv file into an oracle table using an ODBC bulk command ? :confused:

    R 1 Reply Last reply
    0
    • H hatemtaleb

      hello all, is it possible to load data from csv file into an oracle table using an ODBC bulk command ? :confused:

      R Offline
      R Offline
      Rajesh Anuhya
      wrote on last edited by
      #2

      why don't you use Sqlldr.exe for Bulk insert

      Rajesh B --> A Poor Workman Blames His Tools <--

      H 1 Reply Last reply
      0
      • R Rajesh Anuhya

        why don't you use Sqlldr.exe for Bulk insert

        Rajesh B --> A Poor Workman Blames His Tools <--

        H Offline
        H Offline
        hatemtaleb
        wrote on last edited by
        #3

        Because I am coding an application in VB6, I have only an ODBC link to the database

        M R 2 Replies Last reply
        0
        • H hatemtaleb

          Because I am coding an application in VB6, I have only an ODBC link to the database

          M Offline
          M Offline
          Mycroft Holmes
          wrote on last edited by
          #4

          hatemtaleb wrote:

          Because I am coding an application in VB6

          I'm not trying to be rude, but why are you coding in a dead and unsupported language.

          Never underestimate the power of human stupidity RAH

          R 1 Reply Last reply
          0
          • H hatemtaleb

            Because I am coding an application in VB6, I have only an ODBC link to the database

            R Offline
            R Offline
            Rajesh Anuhya
            wrote on last edited by
            #5

            You can Use Sqlldr.exe in VB6.., Why are you going to break your head again for bulk insert concept., there is already well tested component is giving by the Oralce.., Use the Shell executions to execute the sqlldr.., No need of ODBC.., Thanks

            Rajesh B --> A Poor Workman Blames His Tools <--

            1 Reply Last reply
            0
            • M Mycroft Holmes

              hatemtaleb wrote:

              Because I am coding an application in VB6

              I'm not trying to be rude, but why are you coding in a dead and unsupported language.

              Never underestimate the power of human stupidity RAH

              R Offline
              R Offline
              Rajesh Anuhya
              wrote on last edited by
              #6

              my Vote (5) Well Said.., But there is Reason behind that to Use the VB6.., Some of sectors(Govt based(most in india)) still using the Windows 98 OS with Low end Configurations :( :( :( . which is not well supported by our .Net Frameworks..,

              Rajesh B --> A Poor Workman Blames His Tools <--

              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