Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Automatically Generate SQL from existing MS Access table

I've just designed a large database by playing around in MS Access. Now that I'm happy with the design, I need to be able to generate this same database (tables, relationships, etc.) from code.

Rather than hand-writing the SQL CREATE statements (which will be long, tedious, and error-prone process), I was wondering whether there was a shortcut. I seem to recall from my limited exposure to MySql that I was able to export an entire database as an SQL statement that can then be run in order to regenerate that database.

Do you know of a way to do this in MS Access, either through the GUI, or programmatically?

like image 420
Smashery Avatar asked Apr 17 '09 01:04

Smashery


People also ask

How do I get SQL from Microsoft Access?

You have selected certain fields in the Query Grid; at the same time, MS Access has also created an SQL Query with the results obtained from your Query Grid. To view the SQL, go to the Home tab. Select SQL View from the View menu and you will see the SQL of your query.


1 Answers

I just found and tried out this tool: jet-tool. It seems to work well for Access 2010.

like image 191
jpmc26 Avatar answered Sep 19 '22 13:09

jpmc26