:: DEVELOPER ZONE
MySQL Reference Manual :: 25.1.11.2 How to Export a Table or Query from Access to MySQL?
Search the MySQL manual:
- 25.1.11 MyODBC and Microsoft Access
- 25.1.11.1 How to Set Up Microsoft Access to Work with MySQL using MyODBC?
- 25.1.11.2 How to Export a Table or Query from Access to MySQL?
- 25.1.11.3 How to Import or Link MySQL Database Tables to Access?
- 25.1.11.4 The Structure or Location of a Linked Table has been Changed. Can I See Those Changes Locally in Linked Tables?
- 25.1.11.5 When I Insert or Update a Record in Linked Tables, I Get #DELETED#
- 25.1.11.6 How Do I Handle Write Conflicts or Row Location Errors?
- 25.1.11.7 Whenever I Export a Table from Access 97, a Strange Syntax Error Occurs
- 25.1.11.8 Access Returns Another user has modified the record that you have modified While Editing Records
- 25.1.11.9 How to Trap ODBC Login Error Messages in Access?
- 25.1.11.10 How Do I Optimize Access for Performance with MyODBC?
- 25.1.11.11 I Have Very Long Tables. What is the Best Configuration for MyODBC to Access These Tables?
- 25.1.11.12 How to Set the QueryTimeout Value for ODBC Connections?
- 25.1.11.13 INFO: Tools to Export/Import from/to Access to/from MySQL
Additional languages
Additional formats
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
tableorqueryyou want to export, and then in theFilemenu, selectExport.-
In the
Export Object Typedialog box, in theObject nameToSave As Typebox, selectODBC Databases ()as shown here:
In the
Exportdialog box, enter a name for the file (or use the suggested name), and then selectOK.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 25.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.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.