您需要解决两个不同的问题：

You need to solve two different problems:

1. 创建一个具有与MySQL数据库结构匹配的结构的空MS Access数据库。

1. Creating an empty MS Access database with a structure that matches the MySQL database structure.

从MySQL提取数据并加载进入MS Access。

Extracting the data from MySQL and loading it into MS Access.

这并不容易，因为不同的SQL数据库提供不同的结构特性，不同的数据类型等。使用MySQL越复杂，你在转换过程中就越可能遇到一些阻碍（例如，Access根本不支持触发器）。相反，如果你使用MySQL作为一个简单的数据存储，你可能会发现转换相当容易。

This is not easy because different SQL databases offer different structural features, different datatypes, and so on. The more complex your use of MySQL is the more likely you'll run into some show-stopper during the conversion (for instance, Access doesn't support triggers at all). Conversely if you're using MySQL as a simple data store you may find the conversion fairly easy.

要获得一个与你的MySQL数据库结构相同的MS Access数据库，你***的办法是找到一个数据库定义/图表工具，提供逆向工程，并支持MySQL和MS Access。使用它将MySQL数据库反向工程为数据库图表，然后将底层数据库更改为MS Access并使用该工具生成数据库。

To get an MS Access database with the same structure as your MySQL database, your best bet is to find a database definition / diagramming tool that offers reverse engineering and supports both MySQL and MS Access. Use it to reverse engineer your MySQL database into a database diagram, then change the underlying database to MS Access and use the tool to generate a database.

查看 Dezign For Databases （在纸上，无论如何）提供了您需要执行此操作的功能。

Check out Dezign For Databases which (on paper, anyway) offers the features you would need to do this.

为了泵送数据，有许多工具。这种操作通常被称为ETL（提取，翻译，加载）。

To pump the data across, there are any number of tools. This kind of operation is generically referred to as ETL (Extract, Translate, Load).