Manually exporting MS Access tables

Before we start, let's look at some information that will help us decide what tables to move into MySQL and what tables to keep in MS Access. If you are thinking of migrating tables to a MySQL database, then it depends on the application. You also need to consider where your users are accessing the database, as well as the purpose of the tables. In the case of remote users, we only need to list those tables that feed drop-down lists. It may be better to keep these in the application as local tables. On the other hand, tables with MS Access-specific field types such as multivalued fields and attachment fields cannot be migrated. MySQL does not have a comparable field type, so it cannot use them.

Please note that it is never a good idea to store files and images in any database as you can with attachment fields or MySQL BLOB fields. They will make the database grow very large very quickly. It is better to store the path names in the files...