Export Table to SQL for Access

Export Table to SQL for Access is an application you can use to extract tables from databases and save them as INSERT SQL statements for Microsoft Access (and optional CREATE TABLE statements). It offers support for all modern Access editions, as well as text, SQL, Excel and XML output file types.

Suffice it to say, you must have an ODBC driver for Access to be able to use this tool with its full features. The interface consists of a wizard that contains a few steps to get the task done quickly.

You can get started by configuring connection settings using a database server or file as the source. It's possible to exclude any schemas, select all tables or filter them by the WHERE clause row, preview table information, enter SQL queries or load them from file, as well as specify the Access database to use as target.

When tinkering with the output options, you can create/recreate a table or use an existing one to append or replace data rows, copy or reset identity values in data rows or exclude them from the task, as well as include indexes and the primary key in the migration operation.

As far as general settings are concerned, Export Table to SQL for Access can be instructed to drop empty result lines, record logs, or force replace the decimal digits separator with anything else. The project can be saved to file and later opened.

It has advanced, yet approachable options for preparing tables for integration with Microsoft Access, including rich filters. CPU and RAM usage was minimal in our tests, and the app didn't hang, crash or show error dialogs. Help documentation is available. Thanks to its wizard interface, Export Table to SQL for Access can be handled with ease.