(mysql.info) export-of-data

 
 23.1.11.2 How to Export a Table or Query from Access to MySQL?
 ..............................................................
 
 You cannot export a table or query to MySQL unless you have installed
 MyODBC.
 
 To export a table from Access to MySQL, follow these instructions:
 
   1. When you open an Access database or an Access project, a Database
      window appears. It displays shortcuts for creating new database
      objects and opening existing objects.
 
      Access Database
 
   2. Click the name of the `table' or `query' you want to export, and
      then in the `File' menu, select `Export'.
 
   3. In the `Export Object Type OBJECT NAME To' dialog box, in the
      `Save As Type' box, select `ODBC Databases ()' as shown here:
 
      Selecting an ODBC Database
 
   4. In the `Export' dialog box, enter a name for the file (or use the
      suggested name), and then select `OK'.
 
   5. The Select Data Source dialog box is displayed; 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 MyODBC or MyODBC 3.51 data source
      that you want to export to. To define a new data source for
      MyODBC, please  dsn-on-windows.
 
 Microsoft Access connects to the MySQL Server through this data source
 and exports new tables and or data.

Info Catalog

(mysql.info) msaccess-setup

(mysql.info) msaccess

(mysql.info) import-of-data

automatically generated byinfo2html