Inserting MS Access Query Brings in Extra FieldsLast reviewed: February 5, 1998Article ID: Q113704 |
The information in this article applies to:
SYMPTOMSIf you insert data in a Word document from a Microsoft Access database using DDE as the conversion method, Word for Windows inserts all the fields in the query, even though you specify only certain fields. (To insert data, use the Database command on the Insert menu or the Mail Merge feature. To specify fields, choose the Select Fields option in the Query Options dialog box.) By contrast, this problem does not occur when you insert data using a database table or when you use ODBC for the conversion method.
STATUSMicrosoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
WORKAROUNDSMethod 1: Insert the information using an MS Access table for the data source, rather than a query. You can then refine the inserted information from the database based on both fields and records. All the options will be available and usable.Method 2: Insert the information using an MS Access query for the data source. Then delete the unwanted fields by first selecting that column in Word and then choosing Delete Column from the Table menu.Method 3: Insert the information using ODBC as the conversion method, rather than DDE. To choose ODBC, do the following: a. From the Insert menu, choose Database. b. Under Data Source, choose the Get Data button. c. Select the Confirm Conversions check box. d. Open the Microsoft Access database from which you want to insert information. e. In the Confirm Data Source dialog box, select "MS Access Databases via ODBC (*.mdb)." MORE INFORMATION
Steps to Reproduce the Problem
REFERENCES"Microsoft Word User's Guide," version 6.0, pages 624-632, 676-677
|
KBCategory:
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |