Creating a sql dump of Microsoft Access tables

Question

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

score 4 · Answer 1 · edited Nov 18 '20 at 09:39

4

Take a look at Access To MySQL conversion tool, it allows the generation of a dump file ...

edited Nov 18 '20 at 09:39

gtgaxiola

103

answered May 06 '12 at 09:54

aleroot

3,248

score 1 · Answer 2 · answered Oct 28 '10 at 19:26

1

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

answered Oct 28 '10 at 19:26

ahill

2,802

score 0 · Answer 3 · answered Sep 22 '10 at 02:54

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.

Creating a sql dump of Microsoft Access tables

3 Answers3