By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,300 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,300 IT Pros & Developers. It's quick & easy.

export database from MYSQL to Ms Access

P: n/a
Hi,

I want to export database from MYSQL to Ms Access. Can anybody
suggest me a way to do that.

thank you,
amar

Feb 16 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Feb 16, 2:39 pm, contact.amaren...@gmail.com wrote:
Hi,

I want to export database from MYSQL to Ms Access. Can anybody
suggest me a way to do that.

thank you,
amar
Install the MySQL ODBC driver:

http://dev.mysql.com/downloads/connector/odbc/

Create a system DSN for the MySQL database. Create a new Access
database, then do

File Get External Data Import...

In the Import dialog click the "Files of type" drop-down and choose
"ODBC Databases ()". In the "Select Data Source" dialog click the
"Machine Data Source" , select the DSN you created, and click "OK".
Select all of the tables and import them.

Feb 16 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.