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.