Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to generate a sql script that contains CREATE and INSERT statements for some tables within an Access database?

share|improve this question

Take a look at Access To MySQL conversion tool, it allows the generation of a dump file ... Take a look also at this good guide on how to dump data from MS Access .

share|improve this answer

I've used Access to MySQL and Access to MSSQL (both free) before with success.

It can produce SQL Dumps for their respective targets. Download link

share|improve this answer

Jet/ACE supports DDL, yes, but not as fully as some other SQL dialects. It also has its idiosyncracies.

But keep in mind that Jet/ACE can execute only one statement at a time -- no batching of multiple statements in a single "script." Each DDL statement has to be executed one at a time, in succession.

share|improve this answer
Not sure that answered the question... it seems that DDL support was understood as available, but was looking for a solution to generate a SQL script from an existing Access database. Or I could be wrong. – AnonJr Sep 22 '10 at 3:35
You are not wrong ;) – digiarnie Sep 22 '10 at 5:09
That wasn't by any means clear to me from the wording of your question. – David W. Fenton Sep 23 '10 at 21:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.