Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Converting data in MySQL to Access 2003 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Converting data in MySQL to Access 2003" Watch "Converting data in MySQL to Access 2003" New topic
Author

Converting data in MySQL to Access 2003

vernon mweetwa
Greenhorn

Joined: Nov 26, 2004
Posts: 24
Hi,

I would like to find out if there is a way of converting data that is stored in MySQL to Access 2003. This means transfering the whole database with its associated table from one form to another.

Youe response will be highly appreciated.
Masoud Kalali
Author
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

Hi
sure it is possible .
you need to get ODBC driver for Mysql and some utility to pump data from mysql odbcdatasource to Access Database ,MYODBC could be downloaded from www.mysql.com
for Datapum : i have delphi and it come with a data pump software for odbc / bde datasources.
so i think you can use it. otherwise go and check http://www.ems-hitech.com/
they have very good software for working with DBs , and i very good data pump .

hope it helps


Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Converting data in MySQL to Access 2003
 
Similar Threads
Migrating from Ms Sql Server(T-SQL) to Oracle database 10g(PL-SQL)
converting MySQL data to JSON
Reading data from mysql database and converting the data into xml format
reworking Access to mySQL
how I implement a Data Grid in a Java SE Desktop app