| |
26.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:
-
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.
Click the name of the table or
query you want to export, and then in the
File menu, select
Export.
-
In the Export Object Type Object
name To dialog box, in the
Save As Type box, select ODBC
Databases () as shown here:
In the Export dialog box, enter a name
for the file (or use the suggested name), and then select
OK.
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 Section 26.1.9.2, “Configuring a MyODBC DSN on Windows”.
Microsoft Access connects to the MySQL Server through this data
source and exports new tables and or data.
|
|
