Export Access Database to MySQL

In this tutorial, I show how to connect MS Access to MySQL vis ODBC. Then I explain how to export date from Access to MySQL.

[terrystgeorge]

A plain english and excellent presentation. Thanks

[ethanlee]

Wow! Thanks for this video! BTW, if anyone encountered "The specified DSN contains an architecture mismatch between the Driver and Application" during export. Most likely you got the wrong 32/64 bit version of the driver. Access most likely would be on a 32bit so regardless of your machine's, get the 32 bit one ^^

[svendugandzija]

This video just saved me a few hours on my student project. There may be many like it and many forums online that also help but this is the one that helped me out so thank you lol.

[ericsmith]

You are the best! I am exporting my database as we speak. Good job!

[jimraymond]

I've been looking for this solution for a couple of years. Thanks!

[dangerchannel]

Quickly and to the point, thanks a lot!

[stevSteve]

very well explained. useful info. thanks. It's Jan 2022 but still relevant. thank you

[girishkargathara]

Worth watching and very useful
Thanks for sharing

[ahmetkemalakargul]

Great intro, you saved my hours, thank you

[mrz]

It's work. Thanks ! Even now 2019.

[ComAndConquer]

so so thank you man. i know this is old video but now i using this path.

[alanhwu]

Will the change in the access database cause the DB on MySQL change simultaneously ?
If not, what should I do to link my access database to make that happen?

[RicardoBarreraArellano]

So cool for 2 minutes. Un more question. Can you use the same ODBC configuration you have created for linking the mysql db to ms access now or you have to create a new one?

[steveharris]

Great video, is there a report writer that has the same functionality has access in MySQL?

[Thermonator]

Does this transfer all the relationships from access to the mysql server?

[LEARNINGFOREVER]

Thank, you solved to me a big problem with non uni-code fonts

[RicardoBarreraArellano]

Sorry. You did configured some parameters in the ODBC connection form when you were connecting (extracting) your Access data to your MySql server. But, do I have to configured another ODBC (fill another connection form up) in order to import and link now the MySql data to Access?

[elghark]

Stupid question: Do I have to fill my TCP/IP address even if I just want to transfer a database from Acces to Mysql (and vice versa) LOCATED IN THE SAME PC???? Thanks

[fvgoya]

That's what I need!!!

Thanks man!!!!

[hermanmu]

Have you tried it? I do not know off hand. It's been a while since I've had to do that. I believe you can use that single connection.