15.4.7 When using ODBC from Microsoft Excel

• When you execute a query from Microsoft Excel, you cannot specify strings including question marks (?) for values of the extraction condition fields. If you specify such a string, the KAVE07000-E message is output.

• When you obtain data by using the ODBC Driver from Microsoft Excel (Microsoft Query), you need to perform the following settings before filtering the data by date and time.

  Setting location:

  • In Windows

    Time tab (Choose Control Panel, Regional and Language Options, and then click the Customize button. The Customize Regional Options dialog box appears. Click the Time tab.)

  Setting contents:

  • Display the time in the 12-hour time format.

  • Select AM as the symbol to represent morning.

  • Select PM as the symbol to represent afternoon.

• You cannot specify extraction conditions based on multiple tables. Make sure that the columns you specify come from a single table.

To Page Top