| Convert Table from MS Access to Oracle [message #72713] |
Wed, 01 October 2003 04:12  |
sudhanshu
Messages: 5
Registered: April 2002
|
Junior Member |
|
|
My basic purpose is to convert the Access Table in to Oracle Table. I could use Oracle Work Bench. But My requirement is to export the table from MS Access XP to Oracle8i on regular basis.
Please usggest me how to convert the dat either from Text File or CSV or ............
Sudhanshu
|
|
|
|
| Re: Convert Table from MS Access to Oracle [message #72722 is a reply to message #72713] |
Fri, 03 October 2003 00:44  |
LT
Messages: 29
Registered: August 2003
|
Junior Member |
|
|
I would export the table from Access as a CSV either comma deliminated or fixed position, comma deliminated is usually more convenient.
Then just invoke SQL Loader to read in the data.
If you are going to be doing this all the time you could write a little routine that done the Access export and then invoked SQL Loader and done the load.
You can make things even more easier if you just wrote a routine in simple Java (utilising JDBC) that exports the table from access and then connects to the DB using JDBC and then performs the load. Although easier in the long run, you must be careful with this method as any referential integrity constraints will be ignored and you wont get the nice log file that you get from SQL Loader.
Hope that this has helped.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
