How can i access Ms-Access database using MYSQL Query

Question

I want to access MS-ACCESS database using MYSQL query. I want to download some data from MS-ACCESS database table to MYSQL table. But i have no idea to transfer the data from different databases. Please help me to find the solution..

jsist · Accepted Answer · 2012-09-24 12:31:02Z

1

You can use SQLyog's Import External Data Feature to import data from different data sources to MySQL (including MS-ACCESS).

You can go through SQLyog's Help Documentation here.

edited Sep 24, 2012 at 12:31

answered Sep 24, 2012 at 7:43

jsist

5,2534 gold badges30 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marc B · Accepted Answer · 2012-09-24 04:51:07Z

0

You can't. MySQL cannot talk to MS Access. But you can, however, use MS Access to talk to MySQL, if an ODBC data source has been set up pointing at a database stored in MySQL.

You could then use Access itself to do the copying.

answered Sep 24, 2012 at 4:51

Marc B

362k44 gold badges433 silver badges508 bronze badges

1 Comment

romi Over a year ago

Thanks for your reply.Please give me some guidance,if any possible way transfer the MS Access data to MySQL.

Collectives™ on Stack Overflow

How can i access Ms-Access database using MYSQL Query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related