HP OSMS Blueprint: Database Server on HP Server Platforms with MySQL and RHEL5

1. Open the External Data tool bar in Microsoft Excel.
2. Select the data fields you previously imported from MySQL to Microsoft Excel, and then
select Edit Query.
The Microsoft Query dialog box is displayed.
3. Enable record editing by selecting Records→Allow Editing from the main menu, as
displayed in Figure 16. The edits you perform in Microsoft Query are reflected in the MySQL
database.
Figure 16 Enable Record Editing
Connecting External Systems to the MySQL Database 41