(mysql.info.gz) 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 will appear.  It displays shortcuts for creating new
      database objects and opening existing objects.
 
      [image src="Images/myaccess.png" text=""]
   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:
 
      [image src="Images/myaccess-odbc.png" text=""]
   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.gz) MSAccess Setup

(mysql.info.gz) MSAccess

(mysql.info.gz) Import of Data

automatically generated byinfo2html