Export and import

[deathcrussader]

I need to export an existing DB written in Excell or Acces to my server (MYSQL --> PHPADmin) and use that database to acces with PHP...
How???? 🙂
Greetz

[chrima]

Hi there,
You should be able to save the excel file as a CSV (commer seperated value) file from Access.
After doing so, import that file into PHPMyAdmin.
It's been a while since i have attempted this...i remember having to make sure that the mySQL table columns were the same as the Access DB columns.
Also, there is a third party program called "TWANG" which will do it all for you.

Cheers,
chrima