ACC2000: Using SQL to Export to Unicode by Means of the Jet Provider and Text ISAM

You can use Structured Query Language (SQL) to export a table to a Unicode text file by means of the Microsoft Jet Provider and Text ISAM.

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

The first two examples show you how to use queries to import and export text to and from the sample database Northwind.mdb. To set up an example, create a new query (do not add any tables), click the SQL button, and type the corresponding SQL statement. Then, to import or export, just run the query. The third example shows you how to export a table in Unicode format.

Example 1

The following SQL code shows you how to export a table to a text file:

Example 2

The following SQL code shows you how to import a table from a text file (this is the one created in the first example):

Example 3

To modify the SQL statement so that it exports the data in Unicode text format, add the following option to the connection argument: For example, you can modify the statement in Example 1 to the following: