File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Tomcat and the fly likes Can I connect .mdb on linux server through jdbc. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Can I connect .mdb on linux server through jdbc." Watch "Can I connect .mdb on linux server through jdbc." New topic
Author

Can I connect .mdb on linux server through jdbc.

Rajat
Greenhorn

Joined: Mar 20, 2003
Posts: 13
Hi
I have .mdb file on local machine. But I am having the mysql database on the net. I have to update it. Till now, I am generating the text file from MS Access and at the comman prompt i am running the mysqlimport command to update it. but now i have to eliminate the manual process.
What should I do?
I have some options in my mind
1. I can open 2 connection one is for .mdb file on localmachine and other is for mysql . but it is not looking good option.
So, I am planning to have this .mdb file on tthe server(Linux), So i am not sure I can access .mdb file on linux.
2. I should generate the file on the server. and execute mysqlimport through jdbc. but I dont know its possible or not.
Please help me ASAp.

I am stuck.
Thanks in advance
 
 
subject: Can I connect .mdb on linux server through jdbc.