You Can Export Data From Access to the Standard Word Format.

You can export information from your Access database to a Microsoft Word document past using the Consign - RTF File Sorcerer. This article explains how to employ the Export - RTF File Wizard and how to salvage your export settings as a specification for later on reuse.

In this commodity

• Exporting data to Give-and-take: the basics

• Export data to Word

• Sympathize how Access exports objects to Word

• What else should I know?

Exporting data to Word: the basics

You can export a tabular array, query, form, or report to Microsoft Word. When you consign an object by using the Export - RTF File Wizard, Access creates a re-create of the object'southward information in a Microsoft Word Rich Text Format file (*.rtf). For tables, queries, and forms, the visible fields and records appear every bit a tabular array in the Discussion document. When y'all consign a study, the wizard exports the report data and layout  — it tries to make the Discussion certificate resemble the written report as closely as possible.

• Start the operation from Access    To export data from Admission to Word, you demand to work in Access. In that location is no functionality in Word that can import data from an Access database. Y'all also cannot salvage an Access database or table as a Word document past using the Save As control in Admission.

• Objects you lot can export    You can export a table, query, form, or written report. Y'all tin can likewise export only the records selected in a view. Y'all cannot consign macros and modules. When you lot consign a form or datasheet that contains subforms or subdatasheets, only the main grade or datasheet is exported. You need to echo the consign operation for each subform and subdatasheet that you desire to view in Word. Conversely, when you export a report, subforms and subreports that are included in the report are exported, along with the main written report.

• Outcome of the operation    The Export - RTF File Sorcerer always exports formatted information. This ways that only the fields and records that are visible in an object or view are exported along with the display format settings. Columns and records that are hidden, due to filter settings, are non exported. For a report, the layout of the report is too preserved when information technology is exported.

• Merging with an existing certificate    When you export from Admission to a Discussion document, the data is always exported into a new Discussion file. If you want the data to exist inserted into an existing Word document, yous must first consign it from Access into a new Word document, and and then copy the data from the new Word document and paste information technology into the existing certificate. Alternatively, you can copy rows directly from an Access table, query, form, or written report, and so paste them into your existing certificate.

Export information to Word

The procedure of exporting data to a Word document follows these broad steps:

• Prepare your source data for the export. Equally part of this step, y'all make sure that your data does not contain errors, and you determine whether to export some or all of the data in your source table.

• Run the Consign - RTF File Magician.

• Optionally relieve your settings as an consign specification for later reuse.

The steps in the following sections explain how to perform each task.

Prepare for the consign

1. Open up the source Admission database.

2. In the Navigation Pane, select the object that contains the data you lot want to consign.

   You tin can export a table, query, grade, or report.

3. Review the source information to ensure that it does not contain error indicators (green triangles) or error values, such as #Num.

   Ensure that yous have resolved any errors earlier you consign the data to Word. Otherwise, you volition observe that such values are replaced with a null value.

4. If the destination Word document exists and is open, close it before y'all keep. The wizard prompts you lot before overwriting the document.

   Notation:Y'all cannot suspend data to an existing Word document.

5. In the Access database, if y'all want to consign merely a portion of a table, query, or course, open the object and select but the records you desire.

Export the information

1. On the External Data tab, in the Export group, click Give-and-take.

2. The Export - RTF File consign wizard opens.

   

   Notation:The Consign commands are bachelor only when a database is open.

3. In the Export - RTF File wizard, specify the name of the destination file.

4. The sorcerer always exports formatted information. If you want to view the Word document after the export performance is complete, select the Open the destination file after the consign functioning is complete bank check box.

5. If you selected the records that you desire to consign before you started the export performance, you can select the Export only the selected records check box. However, if y'all desire to export all the records in the view, get out the check box cleared.

   Note:This check box appears unavailable (dimmed) if no records are selected.

6. Click OK.

7. If the destination document exists, you lot are prompted to click Yes to overwrite the file. Click No to change the name of the destination file, and and so click OK again.

Admission exports the information and opens the destination document in Word, depending on the export options you specified in the wizard. Access also displays the status of the performance on the final folio of the wizard.

Understand how Access exports objects to Word

The following table describes how Access exports various objects and values to Discussion. This can assistance yous determine what is going wrong if the export operation is not working the way you expect.

Item	Export considerations
Field names	When you export a table, a query, or a class, the field names are placed in the commencement row of the table in the Word document. When you export a report, the placement of the field names in the Give-and-take document varies with the written report layout.
Multivalued fields	A field in Admission that supports multiple values is exported to a single column in Word. The values are separated past commas (,).
Pictures, objects, and attachments	All graphical elements — logos, data in OLE object fields, and attachments that are role of the source information  — are not exported.
Graphs	Microsoft Graph objects are not exported.
Expressions	Expressions are not exported to the Discussion certificate. Just the results of the expressions are exported.
Subforms and subdatasheets	When you consign a form or datasheet, only the master form or datasheet is exported. Yous must echo the export performance for each subform and subdatasheet.

What else should I know?

• For information on how to salvage the details of your export into a specification that you tin can reuse later, see the article Relieve the details of an import or export functioning as a specification.

• For information on how to run saved export specifications, see the article Run a saved import or export performance.

• For information on how to schedule specifications to run at specific times, run into the article Schedule an import or export functioning.

• For data on how to change a specification name, delete specifications, or update the names of source files in specifications, meet the commodity Manage Data Tasks.

Top of Page

jacobsboboy1979.blogspot.com

Source: https://support.microsoft.com/en-us/office/export-access-data-to-a-word-document-6e954c8e-2243-4cb9-8544-607e5b7bfc12

Share this post