Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

3 Answers 3

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
2  
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

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

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

Your Answer

 
discard

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.