From MS Access to MySQL using phpMyAdmin and Excel file format

Learn how to export table from MS Access and import it to MySQL Database using phpMyAdmin and Excel file format.

---

Closed Caption:

hi today we're going to learn how to
export a table from ms access database
and important to my sequel database
using PHP miyabi i have already created
a table inside of the users database and
and now what what I need to do obviously
is to export this table will be
exporting the table using Excel format
so simply right-click on there on the
table you want to export in a table
section inside of the ms access and
select export and Excel once you've
clicked on XO option you going to be
given a few options first of all want to
save it somewhere i'm going to save it
to the desktop obviously fire formats
i'm going to choose the latest version
which is XL sx you can choose the older
one is as well as well if you prefer PHP
myadmin can handle both of them then
click ok and that's everything
now we simply click close and we can
close our msaccess database now I've got
the document which we just exported
opened and openoffice you can see that
the structure is pretty straightforward
we've got an idea of the record with
your first name last name email and
telephone number
there are only about seven records and
in the file which means obviously in the
access database a what we need to do now
is obviously go to our PHP myadmin let's
create a new table i'm going to call it
test and create we go now we got to the
import top select the file on my desktop
open what we need to select from the
format of important file is Excel
depending on which extension you've
chosen you've chosen the latest one XL
sx i'm selecting this one and as you saw
my file content the first row contains
their column names i'm going to take
this one
now click on go and there we go
everything's done if we go to the user
stable as you can see
we've got ID first name last name email
and telephone number down we go to
browse you can see that all these
records have been important important
and obviously called names remain the
same as they were in ms access database