Hi all,
Im new here and hope somebody out there can help me. I'll explain my problem fully in hope that somebody has an answer which will definately work.
I started my 3rd Year Uni project by learning some PHP which was required for database manipulation for a website. I Have a MYSQL database set up and know how to connect and all that, im just terrible at writting in SQL. As i have a large Table with around 30 fields and around 200 records i decided to populate it in MS access and then convert it over to SQL inserts at a later date (expecting lots of tools available) for connection using PHP.
Im now floudered as cannot seem to find a tool required. My MYSQL Database is on a remote server, i do no serving from this machine, and access it for editing using MYSQL and PHPmyadmin through my sites control panel. I only have the database (.mdb) stored locally and so need some method of converting that .mdb file into CSV or SQL inserts that can be entered via PHPmyadmin to populate the SQL database.
Im new to this and hope i've made that clear.
If you know anything about PHPmyadmin or the problem i have please help me.
Many regards in advance
Darren
