Using SELECT-queries in MS Access to MySQL converter

Home > Documentation > MS Access to MySQL

Using Queries for MS Access to MySQL Migration
[MS Access to MySQL Converter] [Introduction to Migration] [Tutorial]

Queries allows to extract partial data for migrating to SQL Server. The following examples are provided to illustrate how to use queries for particular purposes. Assume that we have table "Table1" as below:

   Table1(
	ID Integer, 
	FName Text(50),
	LName Text(50), 
	Birthday Date, 
	Notes Memo
   );

Example 1. Convert certain records.

    SELECT * FROM Table1 WHERE ID > 1000

Example 2. Choose and rename columns.

    SELECT FName as FirstName, LName as LastName FROM Table1

Example 3. Skip records containing NULL values.

    SELECT * FROM Table1 WHERE not isnull(Notes)

Using Queries for MS Access to MySQL Migration