I have db ACCESS with many tables and lots of data registered, I need to import these tables to my new db into MYSQL . Does anyone know a shape? or a tutorial to follow?
I'm using MySQL-Front and phpMyAdmin to do the management.
Use the Access to MySQL . In this link you have a tutorial on how to use: bullzip.com/products/a2m/info .php.
Use this Software Access To MySQL
Introduction
Access to MySQL is a small program that will convert Microsoft Access Databases to MySQL.
> Wizard interface.
> Transfer data directly from one server to another.
> Create a dump file.
> Select tables to transfer.
> Select fields to transfer.
> Transfer password protected databases.
> Supports both shared security and user-level security.
> Optional transfer of indexes.
> Optional transfer of records.
> Optional transfer of default values in field definitions.
> Identifies and transfers auto number field types.
> Command line interface.
> Easy install, uninstall and upgrade.