Results 1 to 4 of 4
  1. #1
    JAVA0282 is offline Member
    Join Date
    Apr 2010
    Posts
    4
    Rep Power
    0

    Default How to Insert data in oracle from Ms access

    Gusy

    i have developed software in oracle & write now there is a requirement to get ms access data & insert in oracle table,so how can it possible through JDBC Driver.\

    thanks in advance.

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    With two connections, of course. JDBC-ODBC connection to MS Access, get the resultset loop through it and add it with addBatch/executeBatch to a preparedstatement opened on a JDBC connection to Oracle.

    Not, necesarily, your best option, but possible. Better would be to export it from MS Access and then load it into Oracle using sqlloader, csv format for the export should work as long as you set up the sqlloader control file properly. No Java involved, and, most likely, faster, once automated properly.

  3. #3
    JAVA0282 is offline Member
    Join Date
    Apr 2010
    Posts
    4
    Rep Power
    0

    Default

    Thanks for Reply

    Actually i have developed tms (time management System) ,This Machine generate data in ms access file every 1 hours ,so i need to create an utility in forms ,when ever user press the button then system get data from ms access & insert in oracle database ,that would be a runtime utility rather then any programmer will be do,

    Also i need your help how can we make both connection in same class file ,can it possible that you can give me a example,

    i am very much thankful.

    ---help---

  4. #4
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    Two Class.forName lines and two DriverManager.getConnection lines. Simply use two different URLs and as long as you have both drivers loaded (with the forName lines) the connection urls will determine which driver gets used. You do know how to get a connection, in general, right?

Similar Threads

  1. Replies: 3
    Last Post: 03-19-2010, 12:59 AM
  2. Replies: 3
    Last Post: 02-28-2009, 09:17 AM
  3. Insert oracle rowtype
    By Faheem_Ahmed in forum New To Java
    Replies: 0
    Last Post: 02-28-2009, 07:12 AM
  4. insert image to oracle using hibernate
    By Thennarasu in forum Advanced Java
    Replies: 12
    Last Post: 01-27-2009, 03:02 PM
  5. Probeleme with insert into database oracle
    By bachtoutou in forum New To Java
    Replies: 0
    Last Post: 05-24-2008, 11:56 AM

Posting Permissions

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