Documentation Home
Connectors and APIs Manual
Download this Manual
PDF (US Ltr) - 4.5Mb
PDF (A4) - 4.5Mb Importing MySQL Data to Access

To import tables from MySQL to Access, follow these instructions:

  1. Open the Access database into which that you want to import MySQL data.

  2. On the External Data tab, choose ODBC Database.

    Figure 5.18 External Data: ODBC Database

    Content is described in the surrounding text.

  3. In the Get External Data dialog box that appears, choose Import the source data into a new table in the current database and click OK.

    Figure 5.19 Get External Data: ODBC Database

    Shows the "Get External Data" dialog with two options: Import the source data into a new table in the current database (selected), and Link to the data source by creating a linked table.

  4. The Select Data Source dialog box appears. It lists the defined data sources for any ODBC drivers installed on your computer. Click either the File Data Source or Machine Data Source tab, and then double-click the Connector/ODBC DSN from which you want to import your table. To define a new DSN for Connector/ODBC instead, click New and follow the instructions in Section 5.5.3, “Configuring a Connector/ODBC DSN on Windows”; double click the new DSN after it has been created.

    Figure 5.20 Select Data Source Dialog: Selecting an ODBC Database

    Shows the "Select Data Source" dialog with two tabs: File Data Source and Machine Data Source. The Machine Data Source tab is selected and displays three columns: Data Source Name, Type, Description. The selected row has "MySQL 5.7" defined as the Data Source Name, and "System" as the Type.

    If the ODBC data source that you selected requires you to log in, enter your login ID and password (additional information might also be required), and then click OK.

  5. Microsoft Access connects to the MySQL server and displays the list of tables (objects) that you can import. Select the tables you want to import from this Import Objects dialog (or click Select All), and then click OK.

    Figure 5.21 Import Objects Dialog: Selecting Tables To Import

    Content is described in the surrounding text.

    • If no tables show up for you to select, it might be because you did not choose the Database to connect to when you defined or logged in to the DSN. Reconfigure the DSN and specify the Database to connect to (see Section 5.5.3, “Configuring a Connector/ODBC DSN on Windows” for details), or choose a Database when you log in to the DSN .

    • If your Access database already has a table with the same name as the one you are importing, Access will append a number to the name of the imported table.

  6. A dialog box appears with a success message if the import is successful. In the dialog box, you can choose to save the import steps for easy repetitions in the future.

    Figure 5.22 Get External Data: Save Import Steps Dialog

    The Save Import Steps dialog shows a check box option titled "Save import steps."