I've used the ExportSQL Access macro with great success in the past. You can find a new version, 3.0, towards the bottom of http://www.rot13.org/~dpavlin/projects.html. I've not used the new version yet, but I will be doing so soon. A couple of minor caveats; it tends to work best with properly normalized data, and there are some libaries that need to be activated if you use it in Access 2K (the program docs will tell you what needs to be turned on)