The information in this article applies to:
SUMMARY
When you use the Data Access Macro (DAM) to extract records from a
remote (external) database you may get different results than you
would if you performed the same extract from a database that is
defined in a local Microsoft Excel file.
WorkaroundTo work around this problem, choose the SQL Query or Query Assistant commands from the Data menu and manually enter the following query:SELECT Table1.name, Table1.address, Table1.city, Table2.phone FROM Table1, Table2 WHERE Table1.city LIKE '%San_%' FOR EXTRACT; PRINTALL; Note that this type of query is case sensitive, so a record containing a city field "santa rosa" would not be selected. To handle cases where the city is lowercase, use an OR operator in the WHERE clause, as in the following example: SELECT Table1.name, Table1.address, Table1.city, Table2.phone FROM Table1, Table2 WHERE (Table1.city LIKE '%San_%') OR (Table1.city LIKE '%san_%') FOR EXTRACT; PRINTALL; Microsoft has confirmed this to be a problem in Microsoft Excel for the Macintosh versions 3.0 and 4.0. We are researching this problem and will post new information here as it becomes available. MORE INFORMATION
When the Data Access Macro extracts information based on defined
criteria and extract ranges it translates the criteria to an SQL query
before it passes the query to the Data Access Language (DAL) software.
Additional query words: 4.00 novell db2 db/2 rdb oracle ingres dal
Keywords : |
Last Reviewed: March 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |