How to import ACCESS data to MYSQL

Asked

Viewed 1,842 times

2

I have a db ACCESS with many tables and a lot of recorded data, I need to import these tables for my new dbin MYSQL. someone knows a way ? or a tutorial to follow ?

I’m using Mysql-Front and phpMyAdmin to manage.

mysql database ms-access
  • 1

    Try that program http://www.bullzip.com/products/a2m/info.php

  • It worked perfect @Hugoleonardo . Hugs.

  • I can post as an answer?

  • Whoa, bring it on.

2 answers

3


Uses the Access to Mysql. In this link has a tutorial (in English) on how to use: Bullzip.com/products/a2m/info.php.

2

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.

Browser other questions tagged mysql database ms-access

You are not signed in. Login or sign up in order to post.