The information in this article applies to:
SUMMARYAlthough Microsoft Query does not have a Find and Replace feature, you can use the SQL language to replace specific field information in a table in Microsoft Query. In some cases, you can also open the table in Microsoft Excel and replace data in the table. The following information describes the methods that you can use to do this. MORE INFORMATIONUsing Microsoft ExcelIf you can open the table in Microsoft Excel, (for example, if the table is a dBASE IV table), you can use the Replace feature in Microsoft Excel to replace field information. To replace information in your table using this method, do the following:
Using SQL StatementIf you cannot open the table in Microsoft Excel, use the following method to replace field information in the table.The following example assumes that you want to locate all of the records in the table Customer, using the NWind data source, where the Country field contains the data USA and replace this data with US. In this example, CUSTOMER.DBF is located in the c:\windows\msapps\msquery directory.
Executed SQL statement successfully
REFERENCESFor more information about the Execute SQL Command (File Menu), choose the Search button in Help and type: Execute SQL Command Additional query words: 5.00 5.00c
Keywords : xlquery |
Last Reviewed: October 5, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |