[Previous] [Contents]

Move Data from an Access Table to a Word Document


The Problem:

I need to use some data from an Access table in a Word document. I've tried selecting rows and then copying and pasting the data, but I don't usually want full rows, and Word seems to give me different formatting each time I paste data from Access, anyway.

The Solution:

For more consistent results, export the entire table in a format that Word can read easily, open the resulting file in Word, and copy the parts you need to your document.

To export from Access, open the table, choose File Export and select the appropriate format in the "Save as type" drop-down list: Rich Text Format if you want all the formatting in the Access table, or Microsoft Word Merge if you want only the text without any formatting. The former creates an actual table in the document, while the latter creates tab-delimited text that you can easily convert back into a table using Word's Table Convert Text to Table command.

In Word, choose File Open, select Rich Text Format or Text Files in the "Files of type" drop-down list, and then open the file you saved. Copy the appropriate parts of the table or text, and paste them into the Word document that needs them.


[Previous] [Contents]