Oracle 5.0, Справочное руководство

Страница: 1797 / 3232

Connector/ODBC Examples
1777
Note
Ensure that the information that you are exporting to the MySQL table is
valid for the corresponding MySQL data types. Values that are outside of the
supported range of the MySQL data type but valid within Access may trigger an
“overflow” error during the export.
Microsoft Access connects to the MySQL Server through this data source and exports new tables and
or data.
20.1.5.4.2. Importing MySQL Data to Access
To import a table or tables from MySQL to Access, follow these 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
.
3. In the
Import
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 source names.
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
.
6. Click each table to
import
, and then click
OK
.
20.1.5.4.3. Using Microsoft Access as a Front-end to MySQL
You can use Microsoft Access as a front end to a MySQL database by linking tables within your
Microsoft Access database to tables that exist within your MySQL database. When a query is
requested on a table within Access, ODBC is used to execute the queries on the MySQL database
instead.
To create a linked table:
1. Open the Access database that you want to link to MySQL.
2. From the File, choose Get External Data->Link Tables.