Using Microsoft Access 2010 how do I export the SQL to an SQL file?

The output should be similar to how phpMyAdmin exports SQL; a phpMyAdmin SQL export file can be imported to a database via a source command in MySQL.

The issue is primarily the challenge between determining if the person who created the database properly structured the data (e.g. I rarely see the id columns in many tables) or if it is Microsoft Access simply over-complicating (or over-simplifying) the view of the database. I simply need to see the exported data in a normal SQL format.

  • 1
    Introduction to importing and exporting data is the first result from google "access 2010 export data" – DavidPostill Oct 23 '14 at 14:26
  • @DavidPostill External Data tab --> XML file. Post it and I'll be happy to accept it as the answer. – user312854 Oct 23 '14 at 14:28
  • @DavidPostill If you do please clarify how to export all tables, trying to figure that out...lots of tables and it only exports one at a time. – user312854 Oct 23 '14 at 14:30
  • Answer added. I don't know about export all tables at once ... but see the other links in the answer .. – DavidPostill Oct 23 '14 at 14:40

Source Introduction to importing and exporting data

This article shows you what kinds of data you can import and export by using Access, and shows you the basic steps to get started with an import or export operation.


Types of data that Access can import, link to, or export

A quick way to learn about the data formats that Access can import or export is to open a database and then explore the External Data tab on the ribbon.

enter image description here

  1. The Import & Link group displays icons for the data formats that Access can import from or link to.

  2. The Export group displays icons for all the formats that Access can export data to.

The following table shows which formats can be imported into, linked to, or exported out of Access:

enter image description here

See also How to import Access 2010 database (.accdb) into MySQL and Automatically Generate SQL from existing MS Access table for other options.

  • The other idea would be use mySQL and link to Microsoft Access. From mySQL create your export SQL from there. With varying datatypes, I'm not sure if the XML export nor the export from mySQL by linking to Access will be give you the best results. It is easy enough to test as LAMP or WAMP is easy to install and work with. – Sun Mar 7 '15 at 0:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy