up vote 2 down vote favorite
share [g+] share [fb]

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

link|improve this question
feedback

3 Answers

up vote 0 down vote

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.

link|improve this answer
1  
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
feedback
up vote 0 down vote

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

link|improve this answer
feedback
up vote 0 down vote

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 .

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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