(mysql.info.gz) 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(s) 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, then Microsoft Access
      displays a list of the fields in the linked table. Click a field
      or a combination of fields that will uniquely identify each
      record, and then click `OK'.
Info Catalog
(mysql.info.gz) Export of Data
(mysql.info.gz) MSAccess
(mysql.info.gz) Linked Tables
automatically generated byinfo2html