File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes General Computing and the fly likes ms access db to mysql linux Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "ms access db to mysql linux" Watch "ms access db to mysql linux" New topic
Author

ms access db to mysql linux

Rema Remulta
Ranch Hand

Joined: Apr 03, 2002
Posts: 51
hi,
Do you know what would be the easist way to implement or solution to have a mysql db from ms access db? or have to do mysql db from the scratch?
any hints?
Faisal Khan
Ranch Hand

Joined: Jun 29, 2003
Posts: 285
There are a number of ways you can achieve this, if you goto the mysql sofware contribution page, there are some VBA functions which produce SQL files from an access database. You can then import these into your MySQL database. (I thouhgt I'll save you the hassle and provide a link: http://www.mysql.com/portal/software/item-98.html)
There are commercial tools which allow this too (here is one: http://www.realsoftstudio.com/sqlporteraccess.php)
In our workplace a popular app was written in access some years ago and due to growth it kept falling over and as a quick fix, I created linked tables so the application thinks its talking to its same old Access table but these are pointing to MySQL behind the scenes.
I hope this helps.


The secret to creativity is knowing how to hide your sources.
Rema Remulta
Ranch Hand

Joined: Apr 03, 2002
Posts: 51
Thanks for the good input and the nice link that you gave that enables my Access db to be converted on MySQl db. It's really cool tool and indeed very easy to do!
But actually, this is just half of the solution of my problem, we need basically to convert our Access db to MySQl db to be run on Linux. Since i don't have experience yet on linux environment, the first consideration was to let myself known of the MySQL Windows. Now that i've already converted my Access db to MySQl db (windows), the next problem would be how to have this MySQL db (windows)on MySQL linux? I assumed that there would be not so much problem on deploying this since they are the same MySQL but just on different platform, but i am not sure of course. My next approach would be installing MySQL on linux and i'll see and try how to solve it. If you have any hints, further suggestions to this that would make things a little easier, i would be grateful to have them.
Thanks,
Rema
Faisal Khan
Ranch Hand

Joined: Jun 29, 2003
Posts: 285
Hi Rema,
Sorry if this reply is far too late to be meaningful. From my experience of doing a port from windows to Linux the only thing you have to be careful about is the naming of the tables due to case sensitivity on linux and not on windows.
For example a table called Faisal_Test on windows can be called from a query as select * from faisal_test however, under Linux, tables Faisal_Test and faisal_test are two different tables.
The reason behind this (as you may already know) is that MySQL stores all the databases and the tables in files on the filesystem under <MySQL_HOME>/data/<database_name>/<all the files of your tables>
I hope this helps.
- FK
[ July 25, 2003: Message edited by: Faisal Khan ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ms access db to mysql linux
 
Similar Threads
MySQL db - migrating from Access (but where is the driver?!)
Advice on Data Base for newbie : Should I take the MySQL exam ?
Tomcat JDBC Realm using MS Access DB
Data Base Tip
strange error