Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Can I connect .mdb on linux server through jdbc.

 
Rajat
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic