Home > Documentation > MS Access to MySQL

Using Queries for Access to MySQL Migration

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)