Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Converting data in MySQL to Access 2003

 
vernon mweetwa
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 531
Java Mac OS X Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic