Mitsubishi Electric MELSEC iQ-R-R00CPU - Page 251

13 DATABASE FUNCTION
13.3 CPU Module Database Access (from External Device) Function
249
13
*1 Rename the ID field.
1. Start Microsoft Access and select "Blank database".
2. Add the following fields.
Field name Data type Data type for when the data is exported to
the database of the CPU module
proID
*1
AutoNumber type: Long integer INT
Enduser Numeric type: Long integer INT
TargetX Numeric type: Single-precision floating point type REAL
TargetY Numeric type: Single-precision floating point type REAL
TargetZ Numeric type: Single-precision floating point type REAL
3. Name the table "RecipeTable" and save it. After saving,
close the table.
4. Right-click on RecipeTable, and select [Export] 
[ODBC Database].
5. When the window to specify the export destination is
displayed, click the [OK] button.
6. On the window for selecting the data source, click the
[Machine Data Source] tab and select the data source of
the CPU module.
• When the default user is not set to the ODBC data source, input the user
name and password.
• When no data source of the CPU module is displayed in the window, add a
database of the CPU module to the ODBC data source. ( Page 246
Adding a database to the ODBC data source)