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.