184.108.40.206. How to Export a Table or Query from Access to MySQL?
You cannot export a table or query to MySQL unless you have
To export a table from Access to MySQL, follow these
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
query you want to export, and then in the
File menu, select
Export Object Type dialog box, in the
Save As Type box, select
Databases () as shown here:
Export dialog box, enter a name
for the file (or use the suggested name), and then select
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 220.127.116.11, “Configuring a MyODBC DSN on Windows”.
Microsoft Access connects to the MySQL Server through this data
source and exports new tables and or data.