|
|
I have developed a desktop application in Visual Basic 6.0 with MS Access as the backend for collecting schools data in a particular state. Many small towns in the state do not have access to Internet as such one has to go to a nearest city where Internet is available and has to upload the MDB file to the State's centralized Oracle RDBMS. I would like to design an application in Java and request suggestions from the forum for an efficient way to do so. 1000 such mdb file are to be uploaded into Oracle. One solution I tried is importing each mdb table manually to text file and then exporting that text to remote Oracle database through Java code. Unfortunately, many of the small towners are less skilled to perform such conversion to text and exporting to Oracle, there is a possibility of errors. Please suggest a way to solve this problem by directly importing each entire mdb file at a single instance to oracle through java. Thanks.
|
|
|
|
Hi,
Once I also got the same problem with MS Acess & mySQL DB, the MBD file occupies more size I think by VB code we can convert Data in to CSV file and Through Java code you can Update into your Oracle. Its quit better, Your validation can also be done there...!
|
|
|
|
|
|
|
|
rmannam
