Home / server / Questions / 183070
In Process
digiarnie
Asked: 2010-09-21 22:06:09 +0800 CST

Creating a sql dump of Microsoft Access tables

  • 772

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

microsoft-access sql

3 Answers

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

    • 4

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

    • 1

  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.

    • 0