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.

---

Closed Caption:

alright so in this video I'm going to
show you how to establish connection
between Microsoft Access and my sequel
and then extract an access database to
bicycle you want to start off by
downloading the odbc drivers make sure
you download the latest one which is 3.5
1.30 and then once downloaded go to your
control panel click administrative tools
that sources and then go ahead and add
in a new data source use the odbc driver
click finish i'm going to call this all
this access see cool
quick test action successful i'm going
to use this first database here and
click ok click OK and then I'm gonna go
open and then I'm gonna open up
Microsoft Access it's basically a buddy
gave me some data from a database that
cleanse using google refined and so now
i want to send it back to sequel and so
what I'm going to do is the external
data more odbc database to change the
name to cardio click ok then machine
data source and click that new source
such created click ok so now it's
uploading the data
ok so in this database there's a total
of nineteen thousand 968 records and
exportation is done so let me go into
PHP myadmin here's the database table
19,000 968 records
browse 18,000 868 so to import data from
my sequel Microsoft Access you would
click this button here and you would use
the same length that you set up earlier
with odbc alright thank you for watching