Microsoft KB Archive/110235

How to Retain Formatting When Exporting MS Access Data

PSS ID Number: Q110235 Article last modified on 11-01-1994

2.00 2.00a 2.00a-CD 2.00b 2.00c

WINDOWS

When you export data, Microsoft Access for Windows writes raw, unformatted data. Use one of the following methods if you want to include formatted Microsoft Access data in your Word for Windows document:


 * 1) In Microsoft Access, close the table/query and copy it to the Windows Clipboard. Then paste it into Word and save the data document.
 * 2) Write a MakeTable query that uses the FORMAT function to specifically format each field. Run the query and then export the resulting table.
 * 3) Write a Select query that uses the FORMAT function to specifically format each field. Use the TransferText macro to export the query.

For more information on the above Microsoft Access procedures, see your Microsoft Access documentation.

KBCategory: kbinterop KBSubCategory: Additional reference words: 1.00 2.00 2.00a 2.00a-CD 2.00b 2.00c conv interopsum w_winword b_waccess ============================================================================= Copyright Microsoft Corporation 1994.