(mysql.info) import-of-data

 
 23.1.11.3 How to Import or Link MySQL Database Tables to Access?
 ................................................................
 
 You cannot export a table or query to MySQL database unless you have
 installed the MyODBC.
 
 *To import or link a table or tables from MySQL to Access, follow the
 instructions:*
 
   1. Open a database, or switch to the Database window for the open
      database.
 
   2. To import tables, on the `File' menu, point to `Get External
      Data', and then click `Import'. To link tables, on the File menu,
      point to `Get External Data', and then click `Link Tables'.
 
   3. In the `Import' (or `Link') dialog box, in the Files Of Type box,
      select `ODBC Databases ()'. The Select Data Source dialog box
      lists the defined data sources 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 the MyODBC or MyODBC 3.51 driver,
      please  dsn-on-windows.
 
   4. If the ODBC data source that you selected requires you to log on,
      enter your login ID and password (additional information might
      also be required), and then click `OK'.
 
   5. Microsoft Access connects to the MySQL server through `ODBC data
      source ' and displays the list of tables that you can `import' or
      `link'.
 
   6. Click each table that you want to `import' or `link', and then
      click `OK'. If you're linking a table and it doesn't have an index
      that uniquely identifies each record, Microsoft Access displays a
      list of the fields in the linked table. Click a field or a
      combination of fields that uniquely identifies each record, and
      then click `OK'.
Info Catalog
(mysql.info) export-of-data
(mysql.info) msaccess
(mysql.info) linked-tables
automatically generated byinfo2html