How to Insert data in oracle from Ms access

[JAVA0282]

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.

[masijade]

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.

[JAVA0282]

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

[masijade]

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?