13 DATABASE FUNCTION
13.3 CPU Module Database Access (from External Device) Function
253
13
Record search from an application
The following provides an example to search the record that matches the specified condition from the production data stored
in the database by connecting to the database of the CPU module by using Excel.
1. Start Excel, and select the [Data] tab [From Other
Sources] [From Microsoft Query].
2. On the window for selecting the data source, 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)
3. On the window for selecting columns of the query
wizard, select the field to be output.
4. On the window for filtering data of the query wizard, set
the search condition.
To Next Page
Loading...
