Import access to MySQL

Microsoft Office 2010

MYSQL 5.5.27.2

1. Open access and select the table you want to export. Select External Data-other-ODBC data source.

2. Eject the Export dialog box to modify the name of the table (default).

3. Click the "OK" button in the Export dialog, and the Select Data Source dialog box appears. You can select an existing data source at the search scope, and if not, click the New button.

4, click the "New" button, pop up to create a new data source, select "MySQL ODBC 5.1 Driver" in the name listed (drag the mouse to the end), click "Next".

5, click "Next" button, pop-up data source to save the Directory selection screen, click the "Browse" button, choose to save the directory, enter the file name (such as test), click on the "Save" button, this screen will display the selected directory and file name.

6. Click "Next" button to display the specified information, click "Finish" button directly.

7. Click the "Finish" button to display the data source configuration information and enter the relevant information.

TCP/IP Server:localhost

User:root

Password: Password set when installing MySQL

Database: Select the names of the databases you want to import

8, click "OK" button, if successful, prompt 8-1, click "Close" can. If prompted 8-2, the database that you want to import already exists in the database. If prompted 8-3, it indicates a password input error or other error.

8-1

8-2

8-3